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