Question concerning Lookup Columns

[Mythblstr]

Is it possible to color code the entries in a lookup column? I attemted to modify the format after a lookup column was already created but it didn't change the color of the entries in the lookup column.
I used:
"Male "[Red];" Female "[Green]
in the format section (in design view) after I had allready created the lookup column with male and female as the entries.

Help!

 

[boblarson]

1. Using formats at table level isn't reliable outside of the tables.

2. You, and your users, should be using a FORM to interface with the data and not in the tables directly. Using a form you can use Conditional Formatting to achieve the coloring you desire.

 

[Mythblstr]

Thank you Bob,
If that's the case I now have a new question. I need to flag a field in a report. I have two responses, Approved and Not Approved. How can I flag each repsonse as a different color in that field? All that I am getting is one option to modify the font in the whole field/Column. Is it possible to flag individual options (Approved as green and Not Approved as red) within one field?

 

[boblarson]

In design view, select that text box and then go to the tool bar FORMAT > CONDITIONAL FORMATTING and set your conditions and formats there.

 

[Mythblstr]

Thank you Bob, that's what I needed, I learned something new!