Report locking up when formating page

[Grace]

I have a report that locks up when I run it using criteria
that displays a large number of records. The report is
based off a query that prompts for three parameters (name,
report start date and report end date.) If I run the
report for a name that returns a small number of records
it works fine, but if the name returns a large number (in
this case there are over 500 records) the report locks up
when formating the page. I have to press Ctrl-Break to
get out.

any thoughts are greatly appreciated.

Thank you,
Grac

 

[SA]

Grac:

Most often the culprit in this situation is that you have VBA code in the On
Format event of your report and that code runs repeatedly as Access formats
sections, retreats and reformats as the report is running. To work around
that simply add this wrapper around your On Format code:

If formatCount = 1 Then
'Your code here
End if

 

[Grace]

Thanks Steve for the information. Unfortunately, I do not
have any code on the report. I checked each section of
the report to ensure that there wasn't any "hidden" code.

I should probably tell you some additional information
about the report. The parameter query that the report is
based on prompts the user to enter a date range and an
[OfficeName]. They can leave the [OfficeName] blank. I
used the guidelines on the following web site to set up
the query.

http://support.microsoft.com/default.aspx?scid=kb;en-
us;103181&Product=acc

If the [Officename] field is left blank then it locks up.

Any ideas? I thought it worked at one point, but doesn't
seem to work anymore.

Thanks again for your help.