hobbit82
asked on
Colouring Data Sheet Rows (MS Access)
Hi
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
Simon
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
Simon
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Knew it was there somewhere...
Appreciate your help.
Regards