adding numbers contained in textboxes

[dmyoungsal]

I have 4 textboxes in my form which may or may not contain numbers (Qty)

I need to add these together into a fifth textbox to use in a calculation. All that happens when I add the together is they are concatenated.

how do I convert the textbox contents to a number format?

The current formula in the textbox is:
=(Nz([txtCount1],0)+Nz([txtCount2],0)+Nz([txtCount3],0)+Nz([txtCount4],0))

 

[Ranman256]

in the textbox property, set the FORMAT
FIXED
2 DECIMALS

(or whatever you need)

 

[dmyoungsal]

that's under Format property isn't it?

I have been looking at the Data tab.

Thank you

 

[missinglinq]

in the textbox property, set the FORMAT
FIXED
2 DECIMALS

(or whatever you need)

Note that you have to do this for each of the four Textboxes that hold the input data!

Linq ;0)>