ACC: MS Access Report Not Visible in MS Word or MS Excel

• Microsoft Access versions 7.0, 97
• Microsoft Excel versions 7.0, 97
• Microsoft Word versions 7.0, 97

SYMPTOMS

Novice: Requires knowledge of the user interface on single-user computers.

When you set the Window Color to black and the Font Color to white in Control Panel instead of accepting the default white Window Color and black Font Color, and then you output a Microsoft Access report to Microsoft Word or Microsoft Excel, the report is not visible. A black window is all that you see.

CAUSE

Microsoft Word and Microsoft Excel have a default setting of black for Font Color. However, Microsoft Word and Microsoft Excel do not have a setting for Window Color; therefore, the window remains set to the Control Panel's setting.

RESOLUTION

There are several workarounds for this behavior. One is to change the Control Panel settings so that the Window Color is something other than black. A second is to highlight all of the text in Microsoft Word (CTRL+A) or all of the cells in Microsoft Excel (CTRL+A) and change the Font color.

MORE INFORMATION

Steps to Reproduce Behavior

1. Click the Start button, point to Settings, and then click Control Panel.

2. In Control Panel, double-click the Display icon, and in the Display Properties box, click the Appearance tab.

3. On the Appearance tab, in the Active Window box, click in the white space. Under Item: Window, set Color to black and under Font, set Color to white.

4. Start Microsoft Access and open the sample data base Northwind.mdb.

5. Click the Reports tab and preview the Alphabetical List Of Products Report.

6. Click the OfficeLinks button's arrow, and then click "Publish It with Microsoft Word" or "Analyze It with Microsoft Excel." Note that Microsoft Word or Microsoft Excel opens with a black window.