Conditional control of back color

[nate]

I have a Class Enrollment Database with a Master Roster report, that details the Students Name, and what class they are enrolled in.

Its quite a long document, and its sorted by student name. What I would like is to be able to assign each class a color, and then that row to have that selected color as the Back Color.

Can anyone think of a way I could make that happen? Thanks.

 

[the_net_2.0]

you can use the ''formatconditions'' collection in vba to do it. last resort obviously, but it does work. once set up, you can do this with a simple SELECT CASE statement.

the other option of course would be to use the interface and enter the conditions into the cond. format wizard one at a time until the choices are reached. I don't know if there's a limit.

the other thing to consider, which would be much easier, would be to put it in excel and do it that way. cond. formatting is much easier and welcome in Excel than Access.