Single values entered as text

[instructorTek]

Hi I make a selection with a combo box and a numeric value (data type single) is entered into a text box. When I try to use the value in the text box in a calculation, it comes out incorrect because it sees the value as a string. Any ideas. e.g. 100 + 100 = 100100

 

[Eupher]

Set the format of the textbox to a numeric format. Or use a conversion function, like CInt() to convert the value.

Ken S.

 

[PHV]

As you talked about Single data type I'd use the Val function instead of CInt.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886