I have built a report, which has formulas, and it runs very slow. I click on a box and it takes forever to do anything. I dont have that problem in other reports, just this one. Anyone have any ideas of why a report runs slow in design view?
I have built a report, which has formulas, and it runs very slow. I click on a box and it takes forever to do anything. I dont have that problem in other reports, just this one. Anyone have any ideas of why a report runs slow in design view?
Probably happening when you are modifying bound forms. What Access attempts to do is to track errors constanlty so lets say you change a field on a bound form access tries to validate the whole form AND the underlying table or query.
I'll bet if you removed the recordsource from the form then saved it and went backl into the design the changes would be almost instant. Give it a try, you can always reattach the recordsource after making amendments.
that makes sense. Ill give that a shot.. thanks