report/form will display ##### if data is too large

P

pdezak

I recently converted my database from 2003 to 2007 and noticed that some of
my data is not being displayed on my report or form view if the data is
larger than the box, it will display ######. If you click in the field you
will see the correct data. I looked at the properties and could not figure it
out. It seems to happen only with the Date/time and Number fields.
 
R

Rick Brandt

pdezak said:
I recently converted my database from 2003 to 2007 and noticed that
some of my data is not being displayed on my report or form view if
the data is larger than the box, it will display ######. If you click
in the field you will see the correct data. I looked at the
properties and could not figure it out. It seems to happen only with
the Date/time and Number fields.
Click to expand...

It's a new feature. Previously numbers were formatted in scientific
notation if they were too long to fit in a control. The new behavior is how
Excel has always worked (I think). You do have the option to turn that off,
but off-hand I don't know where the setting is.
 
P

pdezak

Rick Brandt said:
It's a new feature. Previously numbers were formatted in scientific
notation if they were too long to fit in a control. The new behavior is how
Excel has always worked (I think). You do have the option to turn that off,
but off-hand I don't know where the setting is.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


Rick, Thanks for the help, I will try to figure out if there a way to shut that feature off.
Click to expand...
 
Top