Software Tips & Tricks Safeguarding Properties of a Form in Access 2000 and 2002 (XP)

By Laura Noble

Properties of an Access form can be changed in Form View, which is very handy when the form is being developed. Often, though, it is necessary to prevent users from accidentally (or on purpose) changing the form's properties while doing data entry. To safeguard the form's properties, the Properties option can be disabled in Form View.

1. Open Form in Design View.
   
   
2. Right-mouse click on the form (In Access 2000, verify a section or an object is NOT selected). Select the Properties option.
   
   
   
   Or click the Properties icon on the Standard Toolbar.
   
   
3. The Properties box for the form will open. Click the Other tab.
   
   
4. In the Allow Design Changes row change the setting from All Views (the default) to Design View Only.
   
   
   
   
5. Save Form.
   

Stay tuned to Networking Today in the coming months for more Software Tips & Tricks from Noble Software Solutions.

Laura Noble is the owner of Noble Software Solutions. Laura can be contacted at 519-680-2689 or by e-mail at lnoble@noblesoftwaresolutions.com. www.noblesoftwaresolutions.com

Published in Networking Today, May 2003.