Microsoft KB Archive/120274

= ACC2: Report Output to RTF Format Contains Blank Lines =

Article ID: 120274

Article Last Modified on 6/25/2002

-

APPLIES TO


 * Microsoft Access 2.0 Standard Edition

-



This article was previously published under Q120274



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



SYMPTOMS
A report that you output to a Rich Text Format (RTF) file contains two extra blank lines for each record. These blank lines do not appear when you preview the report.



CAUSE
This problem can occur if a report section's CanGrow property is set to Yes when you output the report to an RTF file.



RESOLUTION
To prevent the blank lines from appearing in the RTF file, set the section's CanGrow property to No. Note that if you are using the CanGrow property to make sure that all the data in a field is printed, setting the CanGrow property to No can truncate the data.



STATUS
Microsoft has confirmed this to be a problem in Microsoft Access version 2.0. This problem no longer occurs in Microsoft Access version 7.0.



MORE INFORMATION
When you output a report to text format, the CanGrow property is ignored and the extra blank lines are not created. When you output a report to Microsoft Excel format, the CanGrow property is used but the extra blank lines are not created.

Steps to Reproduce Problem
 Open the sample database NWIND.MDB and then create a blank, new report based on the Categories table.  Create the following text boxes in the report's detail section:

     Text box: Name: Category ID        ControlSource: Category ID         Top: 0 Left: 0 Width: 1 Height: 0.1667 Text box: Name: Category Name ControlSource: Category Name Top: 0 Left: 1.1 Width: 1 Height: 0.1667 Text box: Name: Description ControlSource: Description CanGrow: Yes Top: 0 Left: 2.2 Width: 1 Height: 0.1667  Set the detail section's Height property to 0.1667 inches. Preview the report. Note that there are no blank lines between records.</li> From the File menu, choose Output To.</li> In the Select Format box, select Rich Text Format, and then choose OK.</li> In the File Name box, type a name for the RTF file and then choose OK.</li> Open the RTF file in any word processor that can open RTF files (such as Microsoft Word for Windows). Note the extra blank lines between the records.</li></ol>

<div class="references_section">