Slow Form Opening: Tabs?

  • Thread starter Thread starter Max Moor
  • Start date Start date
M

Max Moor

Hi All,
The two slowest to open forms in my application have tab controls on
them. There are only two or three tabs, but with a fair number of controls
on them. These are mostly option groups with a few text and combo boxes.
I've been careful to make sure that my controls on each "page" don't
overlap, as I've heard that will slow a form down. Do controls on separate
pages of a tab cause overlap problems? These forms seem too slow to open
for the number of controls on them. Any thoughts would be appreciated.

- Max
 
Max Moor said:
Hi All,
The two slowest to open forms in my application have tab controls
on them. There are only two or three tabs, but with a fair number of
controls on them. These are mostly option groups with a few text and
combo boxes. I've been careful to make sure that my controls on each
"page" don't overlap, as I've heard that will slow a form down. Do
controls on separate pages of a tab cause overlap problems? These
forms seem too slow to open for the number of controls on them. Any
thoughts would be appreciated.
Click to expand...

First:
If you're using A2K or later, check to see if you have the Name
Autocorrect feature enabled. If so, disable it and see if things
improve.

Second:
Each recordsource or rowsource query that must be run when the form
loads can slow down the form slightly, so if there are a lot of them,
that can be a problem. If so, delaying the load of subforms, combo
boxes, and list boxes on tab pages that aren't currently visible,
setting their record/row sources only when the page becomes visible, may
solve the problem.

Third:
See Tony Toews' Access Performance FAQ at

http://www.granite.ab.ca/access/performancefaq.htm
 
Hi Dick & Allen,
Thanks for the pointers. Disabling Name Auto correct did the trick.
I'll run by Tony's page, as suggested, for more tips. Thanks again. - Max
 
Back
Top