This
article applies only to a Microsoft Access project (.adp).
Moderate: Requires basic macro, coding, and interoperability
skills.
↑ Back to the top
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.
↑ Back to the top
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).
↑ Back to the top
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.
↑ Back to the top