February 19, 2009

Easy tricks to make your Access forms run faster

Date: October 2nd, 2008
Author: Mary Ann Richardson

By giving a form less data to digest, you can make it run more efficiently. These two tips can help.

cialis tadalafil 5mg width=”100%” size=”2″ />

The less data Access has to load into memory when you open a form, the better the performance. For example, if a form will be used solely for entering data rather than for 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 before it displays the blank record at the end of the record set. Follow these steps to change the form’s data entry property:

Open the form in Design View and click the Selector button.
In the form’s property sheet, click the Data tab.
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, create one control with the desired properties and make that the default control. To do so, follow these steps:

Add a control to your form and change its defaults according to your form’s requirements.
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.