Colouring Data Sheet Rows (MS Access)

Posted on 2011-10-07
Last Modified: 2012-05-12

We have an admin database that records various things and have a table that records post coming into the office.

In the table there is various columns the user records for each row and we would like to add a RAG (Red, Amber, Green) status to the database as a lookup field so the user can add the post item into the database via a data sheet form which has been created and select the RAG Status so the urgency can be seen.

Once this has been done we would like the colour of that row to show the colour selected.

Is this possible?

Kind Regards


Question by:hobbit82
    LVL 12

    Accepted Solution

    if you open the form in design view, on each field, find the "Conditional formatting" context menu option. this is the place where you can add up to 4 different visible differences (including background color as you asked) according to field values and/or calcualtions (that's 3 conditions + 1 for cases when none of the 3 applies)

    Author Closing Comment

    Thanks ErezMor,

    Knew it was there somewhere...
    Appreciate your help.


    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
    Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
    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…

    732 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