text box

[JonyBravo]

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]

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]

tetx box

No, doesnt work.

Thanks anyway

 

[Malcy]

Might be = Sum(Me.txt1 + Me.txt2)