PRB: Duplicate Values Printed on Report

Article ID: Q109336
Creation Date: 02-JAN-1994
Revision Date: 19-SEP-1996

The information in this article applies to:

Microsoft Access versions 1.0 and 1.1

SYMPTOMS

Multiple instances of the same value are printed in a field on your report, even though only one instance of the value exists in the underlying data.

CAUSE

This problem can occur if there are any nonprintable characters at the end of the value in the underlying data and if the field's CanGrow property is set to Yes. Note that if the CanGrow property is set to No, the problem does not occur.

Note that this problem is most noticeable when using the @QuerySQL table created by the ANALYZER.MDA in Microsoft Access version 1.x. The field SQLStatement contains the nonprintable character.

RESOLUTION

Open the underlying table in Datasheet view.
Select the value that was printed multiple times on the report.
Press END to move the insertion point to the end of the value.
Press BACKSPACE until the insertion point reaches the value's last visible character.

STATUS

This problem no longer occurs in Microsoft Access version 2.0.

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.