Knowledge Base

ACC2: Output To Command Truncates Data

Article ID: 125594

Article Last Modified on 11/6/2000

Microsoft Access 2.0 Standard Edition

This article was previously published under Q125594

SYMPTOMS

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

When you use the Output To command to save the output of a report to MS-DOS Text (.TXT) format, some of the data in the output file may be truncated. All of the data appears correctly when you print or preview the report.

CAUSE

The Output To command ignores the CanGrow property for text boxes and sections when you save to a text file. The data that fits in the text box or section's original size will be output and the rest will be truncated.

RESOLUTION

To work around this problem, either change the size of the text box or section so that all the data fits, or save the report to Rich Text Format (.RTF) instead of text, and then use another application or utility to convert the file to text format.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access version 2.0. This problem no longer occurs in Microsoft Access version 7.0.

Additional query words: outputto cut off

Keywords: kbbug kbusage KB125594