Customizing the Access or Office VBE – Setting font colors and background
I got a question posted on my blog a while back, by Terrence Kuchel on how I had made my VBE (Visual Basic Editor) look the way it does. The changes I have made involves setting the background color, and setting various colors up for different types of text. For example I have made my comments light green. Known VBA keywords are formatted in blue, while standard text such as string or date literals are formatted in white. In the VBE click Tools->Options and select the “Editor Format” tab to customize your own settings.
Hope you found it useful. Please leave comments and feedback, I always enjoy getting reactions.