Discussion Locked

Report display problems in Access

0 helpful
7 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am running Access 97 on a Windows 98 computer and have designed several reports. Some of the reports have very little white space (lots of data in a small font size). When the reports are viewed in Access 97 on a Windows NT or 2000, some of the fields get truncated or for single character fields - they do not display at all.

Are the 2 operating systems interpreting the True Type font (Arial 7pt) differently?

When I create the reports and view them on my Windows 98 screen, how can I be assured they will be properly displayed in Windows NT/2000?

7 replies

by rueggy

If you have used the "Size to fit" feature in the report design, I have found that sometimes the field is sized smaller than what it really should be. I like to expand the field size slightly and that always seems to make the data display properly. This may or may not help in your case. Good luck!

by bugzapper

Is the font available on the PC you are having a problem with - in Word or another application? If the font and size are not set up on the PC, it will substitute another font, possibly a larger one that will not display in the allotted space. I have had this problem in other situations, where font substitutions result in truncated or unreadable text.

Good Luck.

by m_ozog

I stated in my question that I was using Arial 7pt. As far as I know, Arial comes standard on Windows computers and the users do not know how to remove fonts from the system

by is

This may have more to do with your printers than the operating system. I have had similar problems with some of my reports. The problem seems to stem from different computers defining their printers (even if it is the same printer) differently. Some of the formatting that tends to get lost is the page set up and odd sized fonts. (If you typed in the font size rather than select it from the drop down.) I believe the smallest universally accepted font size is 8pt.

My solution was to use the Snapshot Viewer. If they don't need to have the report dynamically on their computer, you can export the report to a sanpshot and Snapshot Viewer is a free download from MS website.

I hope this helps at least a little. One other thing to check is the screen resolution on all of the computers. I know I try to develop my applications for the worst case scenario in a given site. (If the computer with the worst resolution is a 640 X 480, that is what I develop for. This is another thing you may need to look at.

by m_ozog

Thanks for the try. I can't use the Snapshot because these reports are being dynamically created on the end user computers.

The minimum resolution on all of the computers in question is 800x600 (most are 1024x768). Matching the 800x600 has noeffect.

The only differnce that I can find is the defference in the Windows operating systems (Win 9x vs. 2K & NT).

This discussion is closed to new replies.