• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 13. Customizing Access > Creating Conditional Macros

Creating Conditional Macros

Sometimes you may want a macro to run only if some prior condition is met. For example, you could create a macro that prints a report only if the number of records to print is greater than zero. You can do this by creating a conditional expression, an expression that Access evaluates as true or false. If the condition is true, Access carries out the actions in the macro or macro group.

Create a Macro Condition

Open a macro in the Macro window.

Click the Conditions button on the Macro Design toolbar.

Click the Build button on the Macro Design toolbar to open the Expression Builder.

Enter an expression that Access could evaluate as either true or false.

Click OK.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint