1 + 1 + 1 = 111 not 3? Trouble with math and expression builder

[bytreeide]

if for instance I have the following Names of text boxes:



Text001
Text002
Text003

And lets say that each of these currently have a value of 1.

I have written a mathematical operation in Control Source for a fourth text box that looks like this:

= [Text001] + [Text002] + [Text003]

What I am getting is:

111

I was expecting:

3

If I were to change Text002 to equal 2 the the result of the equation would be:

121

My thought is that I have done something wrong with the expression builder.

Suggestions?

[ranman256]

it is interpreting them as text. try
= val([Text001]) + val([Text002]) + val([Text003])

[June7]

+ is valid concatenation character (holdover from ancient BASIC).

The first 3 calcs result in text strings.

At least one of the terms in the 4th calc must be a number to force arithmetic instead of concatenation.

So as ranman points out, convert to number.

[bytreeide]

Thank you so much.

I figured that there was something that I wasn't getting. I even checked to make sure that each of the Control's Format was "General Number" didn't seem to help.