INCREASING TABBED FORM PERFORMANCE

In the days before Access 97, the way most developers created multiple page forms was by simply using the Page Break control and the GotoPage method off the Form object.

As of Access 97, you now have the built-in Access native Tab control to use. Although you can put fields and controls directly on all the pages of the Tab control, this can sometimes really bog down the loading of the form. You can also put subforms on some of the pages. The problem when you start getting a number of pages, even using subform controls on them, is that performance can degrade pretty rapidly.

Tip

If you're using a Page Break control with the GoToPage method, you can now use the Cycle property to help control how your control keys ...

Get F. Scott Barker's Microsoft® Access 2000 Power Programming now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.