SETTING THE CORRECT MODULE OPTIONS FOR MAXIMUM DEBUGGING POWER

The VBA environment in Access now includes the same editor as other Office products, as well as Visual Basic. Because the VBE is now in its own MDI space, you must go to the editor to set the coding environment options.

To change or view the settings of VBA environment, use the Options dialog for VBA. For instance, to change the color of a line of code that has a syntax error in it follow these steps:

1.
Create a new database, or open an existing one.
2.
Press Alt-F11. The Visual Basic Editor opens.
3.
From the Tools menu, choose Options. The VBA Options dialog appears, with the following tabbed pages: Editor, Editor Format, General, and Docking.
4.
On the Editor Format page, ...

Get F. Scott Barker's Microsoft® Access 2000 Power Programming now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.