Formatting Page

[MAX]

I have a report that won't come up. When trying to open
it, there is a message: " Formatting page, press
Ctrl+Break to stop..." The message appears immediately
but doesn't go away. I can look at the design view of the
report, but not the print preview.

Any ideas what is causing the freeze?

Max

 

[SA]

Max:

Look at the code you may have placed in the On Format event of any section
of the report. If you have VBA code there, wrap that code in the
following:

If FormatCount = 1 Then
'Your code here
End if

This is because Access can repeatedly format a section of the report and if
your report has a lot of code in the On Format event that changes layout,
then it can end up in sort of an endless loop.