Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 432
  • Last Modified:

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
0
bthouin
Asked:
bthouin
  • 3
2 Solutions
 
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 CoachmanCommented:
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now