• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 373
  • Last Modified:

Colouring Data Sheet Rows (MS Access)


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


1 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)
hobbit82Author Commented:
Thanks ErezMor,

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


Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

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