reports locking access

  • Thread starter Thread starter Mike Chatfield
  • Start date Start date
M

Mike Chatfield

I have a report that just locks access but the query that
runs this report runs fine. What could be holding this
reposrt from printing.
Thanks
Mike
 
Hard to say.

One cause could be that you have a memo field that is more than a page in length
and you have set the Keep Together property for the section to true. I've seen
that apparently cause Access to keep searching for a page where the entire memo
would fit (and of course never finding it).

The query runs fine, the report hangs.
 
Nothing specific comes to mind.

Try removing all special formatting (keep together, keep on one page) etc. See
if the report works then. If so, then try adding back the features one at a
time until you get a failure.

Are you using sub-reports in your report? If so, make sure that the subreport
is also cleared of any formatting features.
 
Back
Top