Formatting problem

[lipin]

I have a textbox on a report that displays a total in a summary line. It looks ok till the numbers add up to 1000 or more and it displays: 1E+
04

I tried the CanGrow prop. and the Format...Size..ToFit but not expanding to fit the numbers. I could just make the textbox bigger, but then when the numbers are single digits, it will leave some unpleasant spaces( I have several textboxes in a row that are all separate but in the printed report they look like they are a code which is the necessary output)
Is there another way to make the textboxes size themselves to fit the numbers they are displaying without cutting them off?

 

[Rich]

Why not =[Field1]&[Field2] etc on a textbox wide enough to accommodate all

 

[Autoeng]

Can grow only works in the vertical direction which is why you are not seeing the field grow to accomodate the number.

Autoeng