Is this report based on a crosstab query? If so, Access has to run the query
in order to figure out what the field names are, even when you go to design
view.
If that is not the issue, work your way through the items in the Access
Performance FAQ by Tony Toews, at:
http://www.granite.ab.ca/access/performancefaq.htm

Signature
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
>I installed Windows XP SP2 about a week ago and today I
> noticed that Access 2002 is very slow when trying to view
[quoted text clipped - 6 lines]
>
> --David