Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Number Display issue in Print Preview for Access 1

Status
Not open for further replies.

gbarnett2

Technical User
Jan 17, 2012
3
US
Long story short: We have a networked Access database that many users work from. When running reports against this database, a date range is entered and a Print Preview report is generated for the user prior to printing. On one user's computer, and only that computer, one of the fields shows as "###" instead of actual numbers. Now I know that this is an indication that the column width is too small to display the numbers, but this only happens on one individual's computer. Since this is an isolated incident, our DBA is unwilling to change the column width for that column. My question is what other factors may affect the Print Preview view on only one person's computer. Here are the things that I have already tried:

1.) Changing any scale/zoom issues that may be causing the "###" to appear - no help
2.) Changing theme/font displays to change font size so the "###" will show numbers instead - no help
3.) Updating Office suits - no help
4.) Making sure Windows updates are current - no help.
 

How about pointing to (changing) a different (default) Printer?

Have fun.

---- Andy
 
OK, tried that and still having the same issue.
 
I appreciate everyone's help. It ended up being a mismatch in the "check for truncated number fields" settings. Thanks again.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top