Edit

Share via

SetProperty Macro Action (Access custom web app)

  • Article

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

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.

Setting

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.

Remarks

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.