3 colors for listbox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to display a list of names. I'd like the names to be either red, blue
or black depending on whether or not the information associated with those
names has been updated this month.

red-more than a month old
blue-not updated for this month
black-current

I've read that it's not possible to have more than one color in a list box,
but that it is possible to fake it with a subform.

Can anyone tell me how to do this?
thanks
 
Yes, you can do it with a subform. You will need to use conditional
formatting to accomplish the color selections.
 
I appreciate your help. Could you give me some more detail.
I've run into two problems.
1) the form recognizes the first record
2) the form changes the font color for every record based on the first record.
 
What version of Access are you on? I use 2003 and in datasheet view I have
successfully used conditional formats to get different colors depending on
the value of the field?
 
I'm using Access 2000

Klatuu said:
What version of Access are you on? I use 2003 and in datasheet view I have
successfully used conditional formats to get different colors depending on
the value of the field?
Click to expand...
 
Back
Top