Microsoft Office Development and Consultancy

It is possible to add macros to your form fields.

All three types of form field allow you to execute a macro when the form field is enetered or exited.

This means that the form can help complete itself based on the specific entries and selections made by the user.

Select the macro you want to run by seletcting it from the Run macro on section.

Entry

This will execute the macro when the form field is selected

Exit

This will execute the macro when the form field is left either by pressing Tab or clicking on another form field.