Turn Off or Customize Error Checking in Microsoft Access

Article by: Avantix Learning Team

Posted: March 12, 2017

Applies to: Microsoft® Access® 2007, 2010, 2013 and 2016 (Windows)

In Microsoft Access, small green error markers may appear in Design View in forms and reports for a number of reasons. These triangular markers display when there may be an error since Access checks forms, reports and controls against the error checking settings or rules in the Options dialog box. Indicators usually appear in the upper-left corner of a form or report and the upper-left or upper-right corner of a control.

You can turn error checking off completely or set the rules you prefer in the Options dialog. The default settings can cause some irritating behaviour (like flagging unattached controls).

Recommended: 10 Microsoft Access Tips for Working with Select Queries

Change error checking options or rules

To turn off or change error checking options or rules in Access:

  1. Click on the File tab in the Ribbon (or the Office button in 2007).
  2. Select Options or Access Options (2007). A dialog box appears.
  3. Click on Object Designers in the left pane.
  4. In the right pane, select the desired options under Error checking in form and report design view.
  5. Click on OK.

Below is the Access Options dialog as it appears in Access 2010 (and is very similar for other versions):

Microsoft Access Options dialog box with error checking options.

Turn error checking off or on

To turn error checking on or off in the Access Options dialog (Object Designers category):

  1. Check or uncheck Enable error checking.
  2. Click on OK.

Change the error marker color

To change the error marker color, in the Access Options dialog (Object Designers category):

  1. Beside Error indicator color, select an alternate color from the color menu.
  2. Click on OK.

Access error checking rules

The following error checking rules in the Access Options dialog (Object Designers category) are enabled by default::

  • Check for unassociated label and control – when you select a control and a label, Access checks to ensure that the selected objects are associated with each other.
  • Check for new unassociated label – this setting applies only to forms and enables Access to check all new labels to ensure that they are associated with a control.
  • Check for keyboard shortcut error – this setting applies only to forms and causes Access to check for duplicate keyboard shortcuts and invalid shortcuts (such as space characters) and provides a list of alternatives.
  • Check for invalid control properties – Access checks controls for invalid property settings (such as invalid expressions or field names).
  • Check for common report errors – this setting applies only to reports and causes Access to check reports for common errors such as invalid sort orders or widths greater than the selected paper size.

Error checking markers can be very irritating and it’s simple to change or disable error checking settings in Microsoft Access.

Subscribe to get more articles like this one

Did you find this article helpful? If you would like to receive new articles, join our email list.

Recommended Microsoft Access training

Microsoft Access: Introduction

Microsoft Access: Intermediate / Advanced

Microsoft Access: Introduction to VBA (Visual Basic for Applications)

VIEW ALL COURSES

Our instructor-led classroom training courses are delivered at our downtown Toronto location at 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario. Contact us if you’d like to arrange custom training at your office on a date that’s convenient for you.

To request this page in an alternate format, contact us.

Copyright 2017 Avantix Learning Inc

You may also like

How to Easily Export Microsoft Access Data to Excel

Microsoft Access includes an export wizard that can be used to export tables, queries, forms or reports easily to Excel. It’s common to have many users in an organization using Excel so data in Excel format can work well.

Microsoft, the Microsoft logo, Microsoft Office and related Microsoft applications and logos are registered trademarks of Microsoft Corporation in Canada, US and other countries. All other trademarks are the property of the registered owners.

Avantix Learning | 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada M5E 1W7 | info@avantixlearning.ca

Pin It on Pinterest

Share This