Microsoft Access 2010 Bible

Part II: Programming Microsoft Access

420

Tip
You can adjust the editor font and text colors to suit your particular style. In the code editor, choose
Tools ➪ Options to open the Options dialog box. Select the Editor Format tab (shown in Figure 11.3), and you
see all the options for the font, font size, and colors for various parts of the VBA syntax.

FIGURE 11.3

The Options dialog box contains plenty of settings that affect the VBA code window.

Another terrific feature of the Access code window is that the object drop-down list (shown in

Figure 11.4) is alphabetically sorted. If you use a naming convention in your Access code, all the

controls will be grouped by the control type. For example, by using cmd as the prefix for com-

mand buttons, all the command buttons are sorted together in the object list.

FIGURE 11.4

The object list in the Access code window is sorted alphabetically.