Changing font color for comments

[allanc]

Hello Friends!

Wondering if VBA editor allows us to change the font color of the comments?

By comments I mean the texts after '(single quotation mark) - by default it's green.

Thanks!
Allan

 

[theDBguy]

Hi Allan. I wonder if that's a "theme" thing. You know, when you go to File > Options > Client Settings > Default Theme?

 

[allanc]

Hey Friend,

Our codes are shared by multiple users - I think the purpose was to highlight some of the codes(where we made changes) to stand out.

Changing the theme might change the color of everything I assume?

Thanks and sorry for not being clear.

 

[allanc]

Found something under Tools -> Options -> Editor Format to change color of comment text.

This should be good for now

 

[theDBguy]

Found something under Tools -> Options -> Editor Format to change color of comment text.

This should be good for now

Hi. No worries. Glad to hear you got it sorted out. Cheers!

 

[isladogs]

As you've no doubt discovered you can change the comment colour from the default green to blue (or whatever) but it affects all comments, both new and old.