Alison Balteramp;#039;s Mastering Microsoft Office Access 1002003 [Electronic resources] نسخه متنی

Automatic Error Checking

In Access 2003 you can enable automatic error checking of reports. Error checking not only points out errors in a report, but also provides suggestions for correcting them.

You can activate error checking from the Error Checking tab under Tools, Options (see Figure 10.5). Click the Enable Error Checking check box to enable error checking. After you enable error checking, indicators appear on your report, letting you know that something is wrong (see Figure 10.6). You then click the indicator, and an explanation along with suggestions for correcting the error appear (see Figure 10.7).

The error checker will identify several categories of errors, which appear in Table 10.2.

Table 10.2. Categories of Errors Identified by the Error Checker

If Access identifies several errors for the same control, the error indicator remains until all errors are corrected. If you choose to ignore an error, simply select the Ignore Error option on the Error Checking Options menu. This will clear the error indicator until you close and open the report again. Remember that you can turn off error checking entirely via Tools, Options (although I find this feature to be extremely valuable).