Opening Reports in Preview cause ACCESS to hang

[miles-templer]

Have db with 10 reports (print preview). Five show totals
and 5 show details. Totals work fine but details reports
won't open when there is any reasonable amount of data to
view (say 400 items; they work fine when no data). On
opening a details report with data, 'Formatting Page -
Press Ctrl+Break to stop' appears.

Ctrl/Alt/Delete shows Access has hung if you delay
pressing Ctrl Break for too long; if you press Ctrl Break
quickly, you return to the db which then works fine in all
other aspects exept detail reports.

Grateful for any ideas;TIA. Looked at Knowledge Base
Article - 824181 but this apparently applies only to .adp
files.

 

[SA]

You should look at code that you have in the On Format events of your
reports. Often Access reports will format a section and move to the next
section, realize they have to move things in the previous section retreat
and reformat etc. If you've got code in the On Format even it will fire
each time which can make your reports seem enourmously slow. To work
arounds:

1.) Either move the code where possible to the On Print event or
2.) Wrap your code in the On Format event like this:

If FormatCount =1 Then
'Your Code
End if