Show All

Enter an expression in a macro action argument

• 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 instances in which you do not use an equal sign: 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 (.adp).