Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

Note:  This article doesn’t apply to Access web apps.

Some field properties are inheritable. When you create a control that is based on the field, the property setting is included with the new control — inherited from the field that you based the control on. When you change an inheritable field property in table Design view, you can have Access make the same change to any controls that are already based on that field. This process — having Access make the change automatically — is called propagation.

A propagated Description property setting displayed on the status bar

1. When you change an inheritable field property...

2. ...and choose to update the property setting everywhere...

3. ...the new property setting is updated automatically wherever the field is used.

For example, if you update a field's Description property, you can have Access make the same change to controls that are bound to that field, so that the status bar will show the new description when a form is open and a control that uses that field is selected.

Update an inheritable property

  1. Make the appropriate change to an inheritable property. The Property Update Options button appears.

  2. Click the Property Update Options button, and then on the drop-down menu, click Update inherited property everywhere field is used. The Update Properties dialog box opens and displays a list of database objects that use the field.

  3. In the Update Properties dialog box, select all the items that you want to automatically update, and then click Yes.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!