PRB: Print Preview of Datasheet Does Not Show Data

Article ID: Q109368
Creation Date: 02-JAN-1994
Revision Date: 19-SEP-1996

The information in this article applies to:

Microsoft Access versions 1.0 and 1.1

SYMPTOMS

No data is displayed when you are previewing a table, query, or form datasheet, even though records do exist in the underlying record source.

CAUSE

This problem can occur after you change font settings.

RESOLUTION

After you change font settings, save and then close the object. The data will be displayed correctly when you preview the object after you re-open it. Also, avoid selecting white as the color for window text in the Color utility in Microsoft Windows Control Panel.

STATUS

This problem no longer occurs in Microsoft Access version 2.0.

MORE INFORMATION

Steps to Reproduce Behavior

Start the Control Panel.
Double-click the Color icon.
Choose the Color Palette button.
In the Screen Element box, select Window Background. In the Basic Colors area, select a gray color.
In the Screen Element box, select Window Text. In the Basic Colors area, select white.
Start Microsoft Access and open any database.
Open any existing table in Datasheet view.
From the Layout menu, choose Font. Select a different font or size for the datasheet, and then choose OK.
From the File menu, choose Print Preview.

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.