Microsoft Access 2010 Bible

Chapter 14: Debugging Your Access Applications

529

FIGURE 14.4

Auto Quick Info provides syntax reminders in the module window.

Auto Data Tips

Figure 14.5 shows Auto Data Tips in action. This option displays the value of variables when you

hold the mouse cursor over a variable with the module in break mode. Auto Data Tips is an alter-

native to setting a watch on the variable and flipping to the Immediate window when Access

reaches the break point. (You can find out more about watches in the “Setting watches with the

Watches window” section, later in this chapter.)

FIGURE 14.5

Auto Data Tips reveals the value of a variable wherever the variable is used.

Break on All Errors

In addition to the settings on the Editor tab, the General tab on the Options dialog box includes

some powerful settings (see Figure 14.6). These settings are geared more to how VBA operates in

Access, rather than how the code looks or behaves in the VBA code editor.

Break on All Errors forces Access stops at each and every error (regardless of the error handling

you may have added to your application) to allow you to debug the statement generating the error.

During the development process, you’ll want to see errors as they occur instead of relying on the

error handling you built into your code to make sure you understand what’s generating the errors.