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:
Create a new database, or open an existing one.
Press Alt-F11. The Visual Basic Editor opens.
From the Tools menu, choose Options. The VBA Options dialog appears, with the following tabbed pages: Editor, Editor Format, General, and Docking.
On the Editor Format page, ...