ACC2: Output To RTF or TXT Ignores Section's CanShrink Property

ID: Q131828

The information in this article applies to:

Microsoft Access 2.0

SYMPTOMS

Advanced: Requires expert coding, interoperability, and multiuser skills.

When you use the Output To command to output a report to a Rich Text Format (RTF) file or an MS-DOS Text (TXT) file, the CanShrink property of a section is ignored.

STATUS

This behavior no longer occurs in Microsoft Access version 7.0.

MORE INFORMATION

Steps to Reproduce Problem

Open the sample database NWIND.MDB.

Create a blank report based on the Employees table and save it as Report1.

If it is not displayed, choose Field List from the View menu, and then drag the First Name field from the Field List box to the top of the detail section.

Set the First Name control's properties as follows:


       Name: First Name
       ControlSource: First Name
       CanShrink: Yes
       Left: 1
       Top: 0
       Height: .5

Drag the Last Name field from the Field List box to the detail section below the First Name field.

Set the Last Name control's properties as follows:


       Name: Last Name
       ControlSource: Last Name
       CanShrink: Yes
       Left: 1
       Top: .5
       Height: .5

Set the detail section's CanShrink property to Yes.

Preview the Report1 report. Note that there are no blank lines between the Last Name and First Name fields.

From the File menu, choose Output To.

In the Select Format box, select MS-DOS Text (*.txt), and then choose the OK button.

In the File Name box, type the filename canshrnk.txt, and then choose OK.

Switch to File Manager and locate the CANSHRNK.TXT file. Double- click the CANSHRNK.TXT file to open it in Notepad. Note that the records have blank space between the fields.

REFERENCES

For more information about the Output To command, search for "Output To," and then "Output To Command (File Menu)" using the Microsoft Access Help menu.

Keywords : kbusage OtpProb
Version : 2.0
Platform : WINDOWS
Issue type : kbbug