View Full Version : text box


JonyBravo
07-06-2006, 10:16 AM
I've got three text box on my form and I've called them txt1, txt2 and txt3.
On txt3 properties control souce I've wrote the folowing code: = [txt1]+[txt2]
The problem is, If I insert 1 in txt1 and 2 in txt2 most of the times the result I got is 12 instead 3. Can someone tell me why and how can I do this proply?
Thanks for your help.

Jony Bravo

Malcy
07-06-2006, 10:57 AM
You are concatanating the results not adding them.
I think =Sum([txt1]+[txt2]) will work but I might be getting muddled with Excel.
Brain rapidly going dead!
Good luck

JonyBravo
07-06-2006, 11:17 AM
No, doesnt work.

Thanks anyway

Malcy
07-06-2006, 11:38 AM
Might be = Sum(Me.txt1 + Me.txt2)