Access may stop responding when you preview a report (824181)

The information in this article applies to:

Microsoft Office Access 2003
Microsoft Access 2002

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 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.

REFERENCES

For more information about how to group and sort in a report, click Microsoft Office Access Help on the Help menu, type Change sorting and grouping levels in the Search for box in the Assistance pane, and then click Start searching to view the topic.

Modification Type:	Minor	Last Reviewed:	7/29/2004
Keywords:	kbprintpreview kbstoprespond kbView kberrmsg kbReport kbprb KB824181 kbAudDeveloper