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

Posted on 2008-11-09
Last Modified: 2013-11-28

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.

Question by:bthouin
    LVL 13

    Expert Comment

    You can't
    LVL 13

    Expert Comment

    It is controlled by  your  color settings in Windows.  Change those color settings and your tab color will change also.
    LVL 13

    Accepted Solution

    LVL 74

    Assisted Solution

    by:Jeffrey Coachman

    That depends on what you consider "simple"

    Here is one way:
    There is a sample to download as well:
    (You can probably just adapt this to work in your database)


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

    794 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now