O'Reilly logo

F. Scott Barker's Microsoft® Access 2000 Power Programming by F. Scott Barker

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required