I was wondering whether it would be possible to colour rows in a datasheet 
(or continuous form) based on 3 criteria.  Scenario is I have a series of 
jobs that can be either unassigned, assigned and finally "assigned and 
completed".

I would like all rows that are "unassigned" to be one colour; all assigned 
jobs to be another colour and the final section to be a further different 
colour.  

thanking you in anticipation

PMK

On Mon, 17 Dec 2007 09:05:01 -0800, PMK <PMK@discussions.microsoft.com> wrote:

>I was wondering whether it would be possible to colour rows in a datasheet 
>(or continuous form) based on 3 criteria.  Scenario is I have a series of 
>jobs that can be either unassigned, assigned and finally "assigned and 
>completed".
>
>I would like all rows that are "unassigned" to be one colour; all assigned 
>jobs to be another colour and the final section to be a further different 
>colour.  
>
>thanking you in anticipation
>
>PMK

Yes, at least in Access2002 and later. Select the controls that you want to
change color and use the Format... Conditional Formatting menu option.

             John W. Vinson [MVP]