Automatically check your Access 2003 forms for errors

If you work in Access 2003, you can use error checking on your forms. Mary Ann Richardson explains how to activate this feature.

Are some of the controls properties in your forms invalid? Do your forms contain labels with no associated controls? Find and correct these errors before putting your application into production by turning on Forms Error Checking in Access 2003. This automatic facility can alert you to errors as soon as they occur in Design view. To turn on Forms Error Checking, follow these steps:

  1. Go to Tools | Options.
  2. Click the Error Checking tab.
  3. Select the Enable Error Checking check box.
  4. Click OK.

Controls with errors will be flagged in green when a user opens the form in Design view. When the user selects this control, an error indicator button will appear. Pointing to the button will display a message indicating the type of error or errors it found. Click the indicator's down arrow to display a menu giving suggestions and help for correcting the error.

Miss a tip?

Check out the Microsoft Access archive, and catch up on our most recent Access tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

Editor's Picks

Free Newsletters, In your Inbox