ACC2000: Text in Saved Report File Is Wrapped Differently than in the Original Report (208875)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q208875
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

SYMPTOMS

When you save a report in 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 it is truncated differently.

CAUSE

Text width is calculated differently when you use the OutputTo macro action or the Export 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 that this is a problem in Microsoft Access 2000.

MORE INFORMATION

This noticeablility of this problem may vary depending on the font used in the report.

Steps to Reproduce Problem

  1. Start Microsoft Access, and then open the sample database Northwind.mdb or the sample project NorthwindCS.adp.
  2. Open the Alphabetical List of Products report in Design view.
  3. Select the Product Name text box, and then change the font setting to Arial 12.
  4. Preview the report. Note that the text "Chef Anton's Cajun Seasoning" is truncated.
  5. Export the report to a file with MS-DOS Text format either by creating a macro using the OutPutTo action or by using the Export command on the File menu.
  6. View the text file in any text editor (such as Notepad). Note that the text "Chef Anton's Cajun Seasoning" is not truncated.

REFERENCES

For more information about exporting reports to text files, click Microsoft Access Help on the Help menu, type export data or database objects to another database or file format in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

For more information about the OutPutTo action in macros, click Microsoft Access Help on the Help menu, type outputto action in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type:MajorLast Reviewed:6/24/2004
Keywords:kbbug kbnofix KB208875
©2004 Microsoft Corporation. All rights reserved.