ACC2: Report Output to RTF Format Contains Blank Lines

• Microsoft Access version 2.0

SYMPTOMS

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

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

1. Open the sample database NWIND.MDB and then create a blank, new report based on the Categories table.

2. 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
   
   

3. Set the detail section's Height property to 0.1667 inches.

4. Preview the report. Note that there are no blank lines between records.

5. From the File menu, choose Output To.

6. In the Select Format box, select Rich Text Format, and then choose OK.

7. In the File Name box, type a name for the RTF file and then choose OK.

8. 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.

REFERENCES

Microsoft Access "User's Guide," version 2.0, Appendix D, "Using Other Windows-Based Applications with Microsoft Access," pages 737-738