Two tips to make your forms run faster in Access

Make your Access forms leaner and meaner—and faster. By giving your form less data to digest, you can make it run faster and more efficiently. Follow these steps and learn two new ways to make them open and run more quickly.

The less data Access has to load into memory when you open a form, the better the performance. For example, if your form will be used solely for entering data, rather than data searches, you should change the form's data entry property so a blank record opens directly. Otherwise, Access will read in all the records in the file first, before it displays the blank record at the end of the record set. Follow these steps to change the form's data entry property:

  1. Open the form in Design View and click the form's Selector button.
  2. In the form's property sheet, click the Data tab.
  3. Click in the DataEntry property text box, and select Yes.

Another way you can improve performance is to use only default formatting and properties for most or all of the form controls. Your form will load faster because Access does not have to load the non-default form and control properties. If you must change the defaults for most of the controls in your form, first create one control with the desired properties, and make that the default control. To do so, follow these steps:

  1. Add a control to your form and change its defaults according to your form's requirements.
  2. With the control selected, go to Format | Set Control Defaults.

Now, when you add the control to your form, it will have the same properties as the first one. Access saves only the properties of the default control; it does not need to store each control's individual properties.

Miss a tip?

Check out the Microsoft Access archive, and catch up on our most recent Access tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

Editor's Picks

Free Newsletters, In your Inbox