ACC2: Blank Lines in Exported Report Formatted Incorrectly

ID: Q122245

The information in this article applies to:

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 
Issue type        : kbprb

Last Reviewed: April 8, 1999