Enter an expression in a macro action argument

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

  • Type an equal sign (=) followed by the expression. For example, the following expression sets the action argument to the value of the CompanyPickList control:

    =[CompanyPickList]

There are two exceptions: the Expression argument of the SetValue action, and the Repeat Expression argument of the RunMacro action. If you precede an expression in these arguments with an equal sign, Microsoft Access evaluates the expression twice, which can cause unexpected results.

Tip   In a Microsoft Access database (.mdb), click the Build button to use the Expression Builder. The Expression Builder is not available from a Microsoft Access project.

For more information on setting action arguments in a macro, click .