ACC: Text in Saved Report File Wraps Differently

ID: Q125649

The information in this article applies to:

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.


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.


Additional query words: outputto wysiwyg txt 


Keywords          : OtpProb 
Version           : 2.0 7.0 97
Platform          : WINDOWS 
Issue type        : kbbug

Last Reviewed: April 9, 1999