How can I set the color of a tab in a tabbed form in MS Access with VBA code ?

Hi

I have a tabbed form in Access, where I'd like to set the color of the tabs depending on content with VBA code. is there a reasonably simple way to do this ?

Thanks for help.

Regards
Bernard
LVL 1
bthouinAsked:
Who is Participating?
 
wiswalldCommented:
You can't
0
 
wiswalldCommented:
It is controlled by  your  color settings in Windows.  Change those color settings and your tab color will change also.
0
 
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
bthouin,

That depends on what you consider "simple"
;-)

Here is one way:
http://www.fontstuff.com/access/acctut12.htm
There is a sample to download as well:
http://www.fontstuff.com/downloads/ColoredTabsDemo2000.mdb
(You can probably just adapt this to work in your database)

JeffCoachman
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.