Microsoft KB Archive/824181

= Access may stop responding when you preview a report =

Article ID: 824181

Article Last Modified on 5/31/2007

-

APPLIES TO


 * Microsoft Office Access 2007
 * Microsoft Office Access 2003
 * Microsoft Access 2002 Standard Edition

-



This article applies only to a Microsoft Access project (.adp).

Moderate: Requires basic macro, coding, and interoperability skills.



SYMPTOMS
If you try to preview a report that is grouped on one or more fields that have many unique values in a Microsoft Office Access database project, Access may stop responding, and the preview window may display the status as Formatting Page.

Note You may still be able to print the problem report successfully.



CAUSE
This problem occurs when the report is based on a very large recordset and the report is grouped on the fields in the recordset that contain many unique values (in the thousands).



WORKAROUND
To work around this problem, do not preview the report directly in Access if the report is based on a large recordset. Instead, you can use a smaller recordset when you design and preview the report, and then you can switch to the full recordset when you are ready to print the report.

Additional query words: ACC2007 ACC2002 ACC2003 hangs

Keywords: kbprintpreview kbstoprespond kbview kberrmsg kbreport kbprb KB824181

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.