same report displays in 2003 but not in 2007

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?
 
A

Allen Browne

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Access Report Works on One Machine but not Another 3
Print icon from the MS Quick Access Toolbar prints wrong report 1
#Name? displayed in some fields 1
Sharepoint Lookup data field displays Id not data 1
Access 2003 report in access 2007 6
Data showing incorrectly in report 9
Report Date Not Being Displayed Properly 3
Query not returning consistent results 7

Top