The information in this article applies to:
- Microsoft Access version 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" (without the
quotation marks), 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.