How do add the values in two text boxes.

[needadvice]

I have a report that has dollar amounts in 2 text boxes. I'm trying to add the two in a third box.
Control Source =[Text1]+[Text2]. Instead of adding them together it's putting them side by side.
Anyone know why?

 

[Clandon]

Try converting each to a numeric field first, i.e. Integer, Double. Can't remember if this will work on text box, but try.

Control Source =Cdbl([Text1])+Cdbl([Text2])

Hope it works.