Slow Editing Report

[faberk]

I have an Access report that was created some time ago, which is based on a
query. Immediately after I change any control in the report, the report
freezes for about 20-30 seconds and then returns to control to me. Even
simple things like lines changes to lines sizes, this happens. The other
reports in the datbase appear to be fine. I have compacted the database--no
change. Frustration is setting in

Any help please? thanks

 

[Allen Browne]

First thing would be to make sure the Name AutoCorrect boxes are unchecked
under:
Tools | Options | General | Name AutoCorrect
Then compact the database to get rid of this junk:
Tools | Database Utilities | Compact/Repair
Explanation of why:
http://allenbrowne.com/bug-03.html

If the report is based on a crosstab query, you could solve the issue by
specifying all the possible values in the Column Headings property of the
query. That way, Access does not have to run the query to completion before
it can determine the fields for the report.

Other general suggestions for performance issues in Access:
http://www.granite.ab.ca/access/performancefaq.htm

 

[faberk]

Thank you Allen...

The crosstab query appears to have been rather complex. Defining the column
headings solved my problem.