same report displays in 2003 but not in 2007

  • Thread starter Thread starter m galvin
  • Start date Start date
M

m galvin

A few fields in my report display numbers up to 9,999,999.99. If I open the
report in Access 2003 it displays the number. If I open the same report
using Access 2007 it displays ###########.
For some reason this only started to happen around the first week of this
month. On 3-1-10, I have print outs of the report that displayed the numbers
properly using Access 2007. Then suddenly, all the fields began having this
problem. That is all fields displaying any 9 digit figures, as above.
I ideas?
 
Suggestions:

a) Widen the text boxes, so there's enough room to display all the digits.

b) Go to Office Button | Access Options | Current Database, and uncheck the
box for:
Check for truncated number fields.
 
Back
Top