Add in VB

[Guest]

I'm trying to add to text box in a report. Instead of adding the text box it
combining together. How can I get this text box to add together instead of
combing.

Thanks

Example

TextBox1 = 25.25
TextBox2 =1.20

The result = 25.251.20

 

[Rick B]

You can't "ADD" text, you can combine it. A+A=?

I think you could use the VAL function to grab the value of the text and add
it. Try...


Val([TextBox1]) + Val([TextBox2])

Hope that helps,

Rick B

 

[Lynn Trapp]

Access is obviously seeing those values as Text and concatenating them.

You need to convert them to a numeric value first.

= CDbl(Textbox1) + CDbl(TextBox2)

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html