Checking for Errors in Reports and Forms

Checking for Errors in Reports and Forms

As you create reports and forms, Access helps you by catching common errors, such as controls being positioned outside the page size, as they happen. Error checking points out errors in a report or form, and provides you with options using a smart tag button for correcting them. When an error occurs, the Error Checking Options button appears, indicating a problem. Click the button to display a list of options to correct or ignore the problem.

Enable Error Checking

graphics/1_icon.jpg

Click the Tools menu, and then click Options.

graphics/2_icon.jpg

Click the Error Checking tab.

graphics/3_icon.jpg

Select the Enable Error Checking check box.

graphics/4_icon.jpg

To change the color of the error indicator, click the Error Indicator Color list arrow, and then select a color .

graphics/5_icon.jpg

Select or clear check boxes for the specific errors in which you want to check.

  • Unassociated Label And Control

  • New Unassociated Labels

  • Keyboard Shortcut Errors

  • Invalid Control Properties

  • Common Report Errors

graphics/6_icon.jpg

Click OK.

graphics/08inf22.jpg

Error Checking Types

Type

Description

Unassociated label and control

A label and a control, such as a text box or list box, are not associated with each other. The Trace Error button appears instead of the Error Checking Options button.

New unassociated labels

A label to a form or report is not associated with any other control.

Keyboard shortcut errors

A control with an invalid shortcut key; either an unassociated label has a shortcut key, or a label or button has a duplicated shortcut key or a space character as its shortcut key.

Invalid control properties

A control with one or more properties is set to an invalid value.


Correct Errors in Reports and Forms

graphics/1_icon.jpg

When an error indicator (small triangle) appears in a control, select the control.

graphics/2_icon.jpg

Click the Error Checking Options button.

graphics/3_icon.jpg

Click the option you want (options vary depending on the type of error found). Some of the common options include:

  • Help On This Error

  • Ignore Error or Dismiss Error

  • Error Checking Options

graphics/08inf23.jpg



Show Me Microsoft Office Access 2003
Show Me Microsoft Office Access 2003
ISBN: 0789730049
EAN: 2147483647
Year: 2002
Pages: 318

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net