MS Access List Box Change Color

[Guest]

Is there a way to change the back or fore color on a ListBox/Columnlist
object? I have been trying to use the fore color or back color property but
it changes the entire column list and I need only the row with a specific
condition to be a different color. For example if amount > 1000 then set row
color = red. So when the listbox displays all items that particular row will
be in red in the list and will stand out.

 

[Guest]

Use Conditional Formatting. Open your form in Design mode, From the menu bar
Format -> Conditional Formatiing. Follow the instructions

 

[Douglas J. Steele]

I don't believe Conditional Formatting works with List Boxes, Klatuu.

I was going to say that I don't think it's possible to selectively change
colours in a listbox, but then I figured Stephen Lebans probably had
something. Sure enough, check out http://www.lebans.com/listboxenhanced.htm

 

[Guest]

Thank you both for your replies. I will try the hlink you provided.