very sluggish report design

[jpm]

Hello,

Access 2003:

Designing a report that is bound to a recordset is very slow. Every time I
click a field, or anything in the report, there is a painful 1-3 second
delay before focus is set to the control on which I've clicked.

The recordset is, at this point, only returning about 30 records. The
recordsets/query is based upon a couple of base queries; however, there
isn't alot of detail information that is being crunched to obtain results.
e.g. If you run the query serving as the data source for the report, the run
time doesn't exceed more than 5-6 seconds for a return of results.

But, regardless of the processing to render the dataset for the report, why,
in design view is the report so bloody slow?
What configuration options do I need to adjust?

Thanks,

Jim M.

 

[Marshall Barton]

Access 2003:

Designing a report that is bound to a recordset is very slow. Every time I
click a field, or anything in the report, there is a painful 1-3 second
delay before focus is set to the control on which I've clicked.

The recordset is, at this point, only returning about 30 records. The
recordsets/query is based upon a couple of base queries; however, there
isn't alot of detail information that is being crunched to obtain results.
e.g. If you run the query serving as the data source for the report, the run
time doesn't exceed more than 5-6 seconds for a return of results.

But, regardless of the processing to render the dataset for the report, why,
in design view is the report so bloody slow?
What configuration options do I need to adjust?

In my experience, that problem is because Access has to
check the information about the query's fields to make sure
it hasn't changed. Typical reasons for Access not being
able to get it once and used it throughout the design
session is if the query (or any query it is based on) has a
non-specific field list. I think crosstab queries are the
usual culprit, but I suspect the using table.* for a field
list can also cause the problem.

 

[Larry Linson]

Why would you be clicking anything except the forward and backward page
navigation in a Report. Reports are for reading data that you present;
Forms are for clicking, manipulating, and modifying data.

Larry Linson
Microsoft Office Access MVP

 

[M Skabialka]

I am getting the same thing. I am changing reports and forms in an Access
XP database but using Access 2007. Anything new - controls on old forms or
reports, or new forms or reports, is as slow as death - old forms and
reports don't have this problem.
Mich