SetProperty Macro Action (Access custom web app)

Office 2013 and later

You can use the SetProperty action to set a property for a control on a view.

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 SetProperty action has the arguments listed in the following table.

Action argument

Description

Control Name

Type the name of the field or control for which you want to set the property value. Leave this argument blank to set the property for the view.

Property

Select the property that you want to set. See the Remarks section in this article for a list of the properties that can be set by using this action.

Value

Type the value that the property is to be set to. For properties whose values are either Yes or No, use -1 for Yes and 0 for No.

You can use the SetProperty action to set the following properties of a control:

  • Caption

  • Enabled

  • ForeColor

  • Value

  • Visible

If you enter an invalid value for the Value argument, no error occurs, but Access might change the property to a different value, depending on how it interprets the argument.

Show: