SetVariable Macro Action (Access custom web app)

Office 2013 and later

You can use the SetVariable action to create a temporary variable and set it to a specific value. The variable can then be used as a condition or argument in subsequent actions, or you can use the variable in another user interface (UI) macro.

Last modified: March 09, 2015

Applies to: Access 2013 | Access 2016

Important note Important

Microsoft no longer recommends creating and using Access web apps in SharePoint. As an alternative, consider using Microsoft PowerApps to build no-code business solutions for the web and mobile devices.

The SetVariable action has the following arguments.

Action argument

Description

Variable

Enter the name of the temporary variable.

Value =

Enter an expression that will be used to set the value for this temporary variable. Do not precede the expression with the equal (=) sign. You can click the Build button Formula to use the Expression Builder to set this argument.

Show: