NOBLE SOFTWARE SOLUTIONS - WE MAKE IT CLICK!

Disable and Lock Form Fields in Access

By Laura Noble

In an Access form you may have fields that should not be edited or copied. Disabling or locking these fields will speed data entry and also guarantee these fields do not change.

Changing the Enable property of a field from Yes to No will dim the field control as shown in the sample below with the Client ID field. Data cannot be edited or selected/copied when a field is disabled.

After changing the Lock property of a field from No to Yes the field will have normal display, data can be copied but not changed.
 

Changing Enable/Lock Form Properties:

  1. Open the form in Design view.
     
  2. Right-mouse click on the field that requires the enable/lock change.
     
  3. Select Properties.
     
  4. Click the All or Data tab and change the Enable or the Lock settings.

To further speed up data entry remove the Tab Stop from the field by following these steps.

  1. Open the form in Design view.
     
  2. Right-mouse click on the field that requires the removal of the tab stop.
     
  3. Click the All or the Other tab and change the Tab Stop setting from Yes to No.

©Noble Software Solutions - www.NobleSoftwareSolutions.com - 519-680-2689

Home    Why NSS?    Tips & Tricks   Overview    Course Topics    Contact NSS   Training Rates  Media Room  Privacy

Copyright 2000-2008. Noble Software Solutions, London, Ontario, Canada. All Rights Reserved.

Logo Designed by Elly Fox Graphic Designer