View Full Version : Formatting problem


lipin
10-15-2002, 07:23 AM
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
10-15-2002, 10:05 AM
Why not =[Field1]&[Field2] etc on a textbox wide enough to accommodate all

Autoeng
10-22-2002, 01:12 PM
Can grow only works in the vertical direction which is why you are not seeing the field grow to accomodate the number.

Autoeng