Microsoft KB Archive/109820

PRB: Report Wizard Truncates Fields

Article ID: Q109820
Creation Date: 10-JAN-1994
Revision Date: 01-DEC-1996 The information in this article applies to:

Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97

SYMPTOMS

Novice: Requires knowledge of the user interface on single-user computers.

When you create a report using a Report Wizard, some of the report's controls are not large enough to display all the data in the controls. This causes the data in the controls' source fields to appear truncated when you print or preview the report. The amount of truncation depends on the type of printer you use.

RESOLUTION

Increase the size of affected controls so that all the data in the controls can be displayed, or choose a smaller font size for the report.

MORE INFORMATION

Steps to Reproduce Behavior

Create a new table, Table1, with a text field with a field size of 25.
Type "abcdefghijklmnopqrstuvwxy" (without the quotation marks) in the new table.
Use the Report Wizard to create a new report based on the Table1 table. Accept the default wizard options.
Preview the report. Note the truncated field on the report.

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

KBCategory: kbusage
KBSubcategory: RptLayou
Additional reference words: 1.00 1.10 2.00 7.00 97 8.00 truncation wizard