Calculate a sum of numeric textboxes on a form isn't working right

[RayMilhon]

I have a number of text boxes on a form. 6 of them are for data input in kind of a grid format. they are formatted as General number. Then there are totals by row and column. the problem is that the total boxes instead of adding the input as a sum they're appending them so if I have 150, 145 and 175 on the row instead of 470 which is what I want. I'm getting 150145175
The total textbox has a control of =textbox1+textbox2+textbox3. All 4 textboxes are formatted as General Number. I also tried =Val(textbox1) + Val(textbox2) + Val(textbox3) but that just gives me a type! Error so for the moment I'm stumped. any idea is appreciated.

[madpiet]

or maybe
= VAL(me.textbox1) + VAL(Me.textbox2) +...

[RayMilhon]

Sorry I found the problem. one of the textboxes was formatted for short time instead of numeric. Must've twitched or something when I hit the mouse and didn't catch it.