ACC: Text in Saved Report File Wraps Differently

• Microsoft Access version 2.0, 7.0, 97

SYMPTOMS

Moderate: Requires basic macro, coding, and interoperability skills.

When you save a report to MS-DOS Text (.TXT) format or Rich Text Format (.RTF), the text in the resulting file is wrapped differently than in the original report or is truncated differently.

CAUSE

Text width is calculated differently when you use the Output To command than it is when you print or preview a report.

RESOLUTION

Adjust the size of the controls in the report, or change the font, so that the text wraps correctly in the saved file.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access version 2.0, 7.0, and 97. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

This problem may be more or less noticeable depending on the font used in the report.

Steps to Reproduce Problem

1. Open the sample database NWIND.MDB.

2. Open the Alphabetical List Of Products report in Design view.

3. Select the Product Name text box and then change its font to Arial 12.

4. Preview the report. Note that the text "Chef Anton's Cajun Seasoning" is truncated.

5. Save the report to a file with MS-DOS Text format.

6. View the text file in any text editor (such as Notepad). Note that the text "Chef Anton's Cajun Seasoning" is not truncated.