Form Text Box calculation

[mosh]

Hi All,

simple question really. i have 15 text boxes with values that can range from 1-5 or have null values. How can i sum all these values up in another text box?

Thanks,
________
Volcano solid valve or easy valve

 

[pbaldy]

=Nz(Textbox1, 0) + Nz(Textbox2, 0) +...

 

[mosh]

I've just tried the formula, but it is giving me "Yes" in the value of the text box.

Can anyone help?
________
Problems With Nexium

 

[pbaldy]

What is the format property of the textbox? Sounds like it's set to display Yes/No.