Continuous Forms Color Coding

[JRB]

Hello all,

I know this has probably been asked a million times, but I'd like your input.

I have a subform that is being displayed as a continuous form. I need to
have a box on the form that is color coded based on some conditions of the
record: Red for OverDue, Yellow for Behind Schedule, and Green for On
Target. I can't format the object without all the records turning the same
color.

Do any of you have any ideas on how I could accomplish this aside from just
having a regular text field that says Red, Yellow, Green????

Any help would be greatly appreciated!

Janelle

 

[JRB]

I think I may have answered my own question. I created a field in the sql
that feeds the subform which held the text of the color the condition needed
to be ("Red", "Yellow", or "Green"). Then I just used the conditional
formatting to check the value of that field and change the color of it
accordingly.

 

[Marshall Barton]

Yes, you did. That's what I would have suggested as a quick
way to do it.

A more flexible way would be to add the color code to the
table with the "Overdue", etc. text. If you don't have such
a table, consider adding it so that the tasks(?) table only
uses a foreign key into a new "status" table. Then the
form's record source query can join that table to pick up
the text and the color code without hard coding the values
in the query. This way, you can change the text or color
code without having to rewrite the query.