ACC2: Blank Lines in Exported Report Formatted Incorrectly

 Last reviewed: May 29, 1997
Article ID: Q122245
The information in this article applies to:
  • Microsoft Access version 2.0

SYMPTOMS

Moderate: Requires basic macro, coding, and interoperability skills.

When you export a report from Microsoft Access to Microsoft Word version 7.0 or version 6.0 for Windows by choosing the Output To command from the File menu and then selecting Rich Text Format, blank lines in the exported Word document are formatted with a different font than the rest of the report. The blank lines are formatted with the MS Sans Serif font, while the rest of the document is formatted with the same font used in the original report.

RESOLUTION

Follow these steps to reformat the document in Microsoft Word so that the entire document uses the same font:

  1. Open the document in Microsoft Word.

  2. From the Edit menu, choose Select All.

  3. From the Format menu, choose Font.

  4. Select the font you want.

STATUS

This behavior no longer occurs in Microsoft Access version 7.0.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Open the sample database NWIND.MDB.

  2. In the Database window, select the Alphabetical List Of Products report.

  3. From the File menu, choose Output To.

  4. In the Select Format box, select Rich Text Format (*.rtf), and then choose OK.

  5. In the File Name box, type a name for the Word document, and then choose OK.

  6. Start Word and open the document you created in step 5. Click Tools, Options, View and check the All box for the Nonprinting characters. Note that blank lines in the report are formatted with a different font than the text.

Keywords : kbusage OtpProb
Version : 2.0
Platform : WINDOWS
Hardware : X86
Issue type : kbprb
Resolution Type : kbfix

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.

Last reviewed: May 29, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.