MS Access List Box Change Color

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

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.
 
Use Conditional Formatting. Open your form in Design mode, From the menu bar
Format -> Conditional Formatiing. Follow the instructions
 
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
 
Back
Top