"+" is both an arithmetic and a string operator. As a string operator, it

concatenates the two values. This is what you are seeing! Access thinks Box1 and

Box2 in the expression in the control source are both strings so it concatenates

to get 23. Format Box1 and Box2 as number and you will get the arithmetic

operation you want in the TotalBox.

--

PC Datasheet

Your Resource For Help With Access, Excel And Word Applications

re******@pcdatasheet.com www.pcdatasheet.com
"RC" <rc*********@yahoo.com> wrote in message

news:3c**************************@posting.google.c om...

I have a form with three text boxes on it. I want the third text box

to show the total of the values in the other two text boxes.

The first box is named: BoxOne and I type the number 2 into it

The second box is named: BoxTwo and I type the number 3 into it

If the third box is named: TotalBox

and the control source for the TotalBox reads, =([BoxOne]+[BoxTwo])

the value in the total box is 23, not 5

It just places the two separate values side-by-side in the totalbox.

If I use =([BoxOne]*[BoxTwo])

then I get 6 (two TIMES three) I tried using sum in various ways

but I just got error messages. Can anyone help with this.