different colored fonts for item in row source

[rhomer]

I have a list of items in my table's row source. Is it possible to have each item a different color? If not, how would I go about getting each item in a drop down list a different color.

 

[Jaro19a]

Good question, I would like to know that to.

Jeremy

 

[Pat Hartman]

There is only one set of properties for a combo so you can't have different colors for different lines. You can use conditional formatting to have different colors for items in a continuous form.

 

[Jaro19a]

How is that done?

 

[Pat Hartman]

By following the directions in help under conditional formatting.

 

[suemack]

Conditional formatting controls.

I was going to suggest conditional formatting as well. But as stated earlier, a combo box only has one set of properties. I don't know if it would work for you but you might be able to work with an Option Group.. there you have access to one set of properties for each option.
To work with conditional formatting, if you right click on the control and choose conditional formatting it will become pretty self explanatory from there.

 

[rhomer]

Thanks for all the help. I'll try it out.