adding up values in text boxes

[jbennett via AccessMonster.com]

i have about 14 text boxes i need to add up when i hit a button and then the
total will be displayed in another text box. so i created the botton then put
in code and i declared variables like this:

dim rg1 as integer

rg1 = txtrg1.text

i do that for all 14 boxes but when i run it it's say that i need focus on
control or something for it to work. i was wondering if anyone can help me
out. thanks. if you need more info just let me know.

 

[jbennett via AccessMonster.com]

nevermind i realized i needed to use .value

i have about 14 text boxes i need to add up when i hit a button and then the
total will be displayed in another text box. so i created the botton then put
in code and i declared variables like this:

dim rg1 as integer

rg1 = txtrg1.text

i do that for all 14 boxes but when i run it it's say that i need focus on
control or something for it to work. i was wondering if anyone can help me
out. thanks. if you need more info just let me know.

 

[JethroUK©]

try rg1 = txtrg1

(no .text - it needs focus for this - hence the error msg)

 

[fredg]

i have about 14 text boxes i need to add up when i hit a button and then the
total will be displayed in another text box. so i created the botton then put
in code and i declared variables like this:

dim rg1 as integer

rg1 = txtrg1.text

i do that for all 14 boxes but when i run it it's say that i need focus on
control or something for it to work. i was wondering if anyone can help me
out. thanks. if you need more info just let me know.

In Access, it is a control's Value property, not it's Text property,
you need to sum.
See VBA help.

[Total] = Nz([Control1]) + Nz([Control2]) + [Nz([Control3]) + etc.

While you're in VBA help, look up the Nz function as well.

 

[jbennett via AccessMonster.com]

thank you very much.

i have about 14 text boxes i need to add up when i hit a button and then the
total will be displayed in another text box. so i created the botton then put

[quoted text clipped - 7 lines]

control or something for it to work. i was wondering if anyone can help me
out. thanks. if you need more info just let me know.

In Access, it is a control's Value property, not it's Text property,
you need to sum.
See VBA help.

[Total] = Nz([Control1]) + Nz([Control2]) + [Nz([Control3]) + etc.

While you're in VBA help, look up the Nz function as well.