Change backcolor in Access subform in Datasheet view

Posted on 2010-01-08
Last Modified: 2013-11-28
I have researched and researched this, and something quite simple seems rather challenging.

We have many to many relationships setup between a contract and Regions and Manufacturers.  The subforms work great, but we want the background to be white to blend in with the rest of the form.  WE want the dark gray to be transparent or white.

We have scoured properties, and tried things like me.datasheetbackcolor =
on the On Open event of the subform.

Question by:sharpapproach
    LVL 39

    Expert Comment

    You cannot change the color of the headers or record selector in the datasheet view. You can create a continuous form to look like a datasheet and change the colors of the headers for that. However you will still not be able to change the color of the record selector.
    LVL 34

    Accepted Solution

    Here is a link to a Lebans Holding that shows you the way to change the Application back color ie. the Gray behind the DBI.

    His code uses a form to change the color.

    AFAIK, the only way to change the Datasheet Gray is to change the Application Gray.


    Author Closing Comment


    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

    755 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

    23 Experts available now in Live!

    Get 1:1 Help Now