On Change property

See Also

This is where you can specify the action(s) to be executed whenever the selected field/column is changed by the end-user. These actions are performed whenever the field value is changed. For instance, if the user types a new string value in the field, they are re-executed at each individual keystroke. The actions are also executed at the moment that the window containing the object concerned is opened.

These actions are also performed in Query Mode. They are also executed when the user clicks on the currently active option of an Option Buttons control.

You can also perform last-minute corrections to input data using the Adjust Change property.

For more information on when this property is handled relative to other similar properties, please refer to the help index entries on Events.