Monday, July 28, 2014

How To Updating Field Properties in Access 2003

How To Updating Field Properties in Access 2003

When you make property changes to a field in Table Design view, you can choose to update the corresponding property of controls on forms and reports that are bound to the field. When a bound control inherits a field property change, the Property Update Options button appears in Table Design view, where you can choose the Update command. If a bound control doesn't inherit the field's property change, Access doesn't update the control's property.

Update Field Properties

graphics/1_icon.jpg
Display the table in Design view.
graphics/2_icon.jpg
Click the field property box you want to change.
graphics/3_icon.jpg Click the General or Lookup tab, and then change a property.
If you changed the value of an inherited property, the Property Update Options button appears.
graphics/4_icon.jpg
Click the Property Update Options button, and then click Update.
graphics/5_icon.jpg
Select the forms or reports that contain the controls needed to be updated, and then click Yes.
graphics/04inf06.jpg

Turn Off Property Update

graphics/1_icon.jpg
Click the Tools menu, and then click Options.
graphics/2_icon.jpg
Click the Tables/Queries tab.
graphics/3_icon.jpg
Clear the Show Property Update Options Buttons check box.
graphics/4_icon.jpg
Click OK.
graphics/04inf07.jpg