Giving your form less data to digest can make it run more efficiently for you.
The less data MS Access has to load into memory when you open your form, the better it will perform for you. If your form is to be used solely for entering data rather than for data searches, it makes sense to change the data entry property in your form so a blank record opens directly. Otherwise, Access will read all the records in the file before it displays the blank record at the end of the record set.
Follow the steps below to learn how:
- Open the form in Design View and click the Selector button.
- In the form’s property sheet, click the Data tab.
- Click int he DataEntry property text box and select Yes.
You can improve performance also by using only default formatting and properties for most or all of your 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 properties and make that the default control.
Follow the steps below to add a control to your form and change its defaults for those compatible with the requirements of your form.
- 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. MS Access saves only the properties of the default control; it does not need to store each control’s individual properties.