Propagate changes in field properties to bound controls

When you make a change to a field's inherited property in Table design view, you can choose to update the corresponding property of controls on forms and reports that are bound to the field. If a bound control does not inherit the field's property value, and has a different value specified in its property sheet, Access does not update the control's property.

1. Open the table that contains the field in Design view.
2. Under Field Name, click the field whose property you want to change.
3. Change the description of the field, or one of the properties in the General or Lookup tab, and press Enter.

   If you changed the value of an inherited property, you will see the Property Update Options button next to the property name.

4. Click the Property Update Options button, then click the Update... command.
5. In the Update Properties dialog box, select the forms and reports that contain the controls that must be updated, and click Yes.

Notes

• This functionality is not available in Access projects. In Access databases, the Property Update Options button does not update controls on a data access page. If the updated field is in a linked table, Access will not update the objects in the source database.
• You can turn off the display of the Property Update Options button by clearing the Show Property Update Options buttons check box in the Options dialog box.