Set the value of a property in response to an event by using a macro

1. Create a macro.

   How?

2. In a blank action row, click SetValue in the action list.
   
   
3. Set the Item argument to the identifier for the property whose value you want to set, and then set the Expression argument to the value you want to assign to the property.

   

4. Click Save to save the macro.
   
   
5. Go to the form or report, open the property sheet for the object whose event will run the macro, and set the event property to the name of the macro.

For an example of setting the value of a property in response to an event, click .