By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,037 Members | 1,839 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,037 IT Pros & Developers. It's quick & easy.

Adding text boxes

P: n/a
Im trying to add
txtBox1 + txtBox2 + txtBox3 + txtBox4 + txtBox5 + txtBox6 + txtBox7 +
txtBox8 + txtBox9 + txtBox10 = txtBoxTotal
Now im to write some code so everytime i enter a number into a text box
it will give me a running total in txtBoxTotal. What i'm having
problems with is when the rest are null i get errors and the total
doesnt come up in the bottom.
Please let me know if anyone can help.
Thanks

May 18 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On 18 May 2006 12:01:50 -0700, th******@gmail.com wrote:
Im trying to add
txtBox1 + txtBox2 + txtBox3 + txtBox4 + txtBox5 + txtBox6 + txtBox7 +
txtBox8 + txtBox9 + txtBox10 = txtBoxTotal
Now im to write some code so everytime i enter a number into a text box
it will give me a running total in txtBoxTotal. What i'm having
problems with is when the rest are null i get errors and the total
doesnt come up in the bottom.
Please let me know if anyone can help.
Thanks


look up the Nz function in VBA help.
txtBoxTotal = Nz([Text1]) + Nz([Text2]) + Nz([Text3]) + etc.

The value in txtBoxTotal should NOT be stored in any table.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
May 18 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.