Using addition in a control source

[Roncc]

I have a set of text boxes on a form whose contents can either be null or "adult". These textboxes are [Text167], [Test169], [Text170], etc. (for a total of 10 TextBoxes).

I have a second set of Textboxes whose control source formulas are

=IIf(([text167])="adult",1,"0"), =IIf(([text169])="adult",1,"0"), =IIf(([text170])="adult",1,"0"), etc. for a total of 10 textboxes.


The Textboxes in this second set have the control identifiers [Text262] [Text264] [Text266], etc. for a total of 10 textboxes. The last of these textboxes is [Text282].

I have a final text box that I want to use to add up all the numbers in the second set of text boxes (Text262,], [text264], [Text66], etc.) using the control source formula

=[Text262]+[Text264]+[Text266]+[Text270]+[Text272]+[Text274]+[Text276]+[Text278]+[Text280]+[Text282]

This works fine if at least one of the second set of Textboxes , the ones containing the formula =IIf(([text###])="adult",1,"0"), has a 1 in it but, if all these textboxes have a 0 in them the final text box will read 0000000000, not just 0.

It is almost like the final textbox is concatenating all the zero's instead of adding them.

Any ideas? Thanks in advance.

Roncc

[Micron]

"0" is text. 0 is a number. Remove the quotes.
What you're doing seems kind of convoluted but if you're happy with it and have a good reason then ignore that.
EDIT: so yes, you are concatenating.

[Roncc]

Thank you so much. That did the trick. When you're in the thick of things you sometimes can't see the forest for the trees.

[Micron]

Glad I could help.

[Welshgasman]

Thank you so much. That did the trick. When you're in the thick of things you sometimes can't see the forest for the trees.

Having everything called Textnnn cannot possibly help either?