Adding Problems

  • Thread starter Thread starter DS
  • Start date Start date
D

DS

I have 2 unbound Textboxes set to general number format.
If I do...
Textbox1 = 4 Textbox2 = 2

Textbox1 * Textbox2 = 8 Correct!
Textbox1 / Textbox2 = 2 Correct!
Textbox1 - Textbox2 = 2 Correct!
Textbox1 + Textbox2 = 42 Wrong !!!

it should be 6 why is this happening?

Any insight appreciated.
Thanks
DS
 
DS said:
I have 2 unbound Textboxes set to general number format.
If I do...
Textbox1 = 4 Textbox2 = 2

Textbox1 * Textbox2 = 8 Correct!
Textbox1 / Textbox2 = 2 Correct!
Textbox1 - Textbox2 = 2 Correct!
Textbox1 + Textbox2 = 42 Wrong !!!

it should be 6 why is this happening?

Any insight appreciated.
Thanks
DS
Click to expand...

The values are being interpretted as strings rther than numbers. Try...

CDbl(Textbox1) + CDbl(Textbox2)

If the TextBoxes will never have any decimal values then you could use...

CLng(Textbox1) + CLng(Textbox2)
 
Rick said:
The values are being interpretted as strings rther than numbers. Try...

CDbl(Textbox1) + CDbl(Textbox2)

If the TextBoxes will never have any decimal values then you could use...

CLng(Textbox1) + CLng(Textbox2)
Click to expand...
Rick, worked great! Thank you once again!
DS
 
Back
Top