Simply summing text boxes

[XaloRichie]

I have a form with 8 textboxes which are unbound and have calculated values. Can I sum them. eg text1 to text8?

How?

 

[Mile-O]

In the ControlSource:

=[Text1]+[Text2]+[Text3]+[Text4]+[Text5]+[Text6]+[Text7]+[Text8]

 

[XaloRichie]

OK If I have to

So I can't use Sum and a range or anything ?

Im sure I once used something like that in VB5.

OK it will have to be the +'s

Ta!

 

[XaloRichie]

it don't like it

And im still getting #Error

 

[WayneRyan]

Richie,

Are all the entries in the textboxes valid numbers? And check
to make sure that the textbox that you are summing them
into has a format of number.

Wayne

 

[XaloRichie]

you got it

one was not defined correctly
thanks

 

[neileg]

If any of your text boxes can be null, the formula will fail. If this is a possibility and you want to treat a null as a valid entry use the NZ() function to turn the null into a number (presumably 0)

 

[XaloRichie]

Thanks Neil

Th NZ() Is cool to know cheers.

 

[Mile-O]

Might as well add that, sometimes if (by some way or another) the two values in textboxes seem numerical but are in fact text such as "32" and "67" then adding these doesn't actually give you 99, but "3267". Yes, sometimes numbers are concatenated so another useful function can be Val().

ie.

=Val(Nz([txtMyText]))

 

[XaloRichie]

cool

So does that return zero 0 i'll go try it

 

[Mile-O]

That will also return 0 if the textbox has a value of 0 or has the NZ function around it.