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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change List Box Selected Item Fore/Background Colors 2
Option Group ListBox Row Source "Expected end of statement" 0
Change Fore Color in text box 1
forms datasheet 3
How to lock/unlock controls? 3
Excel VBA 1
Can't get rid of alternate row color 6
change colors on selected record 1

Back
Top