MS Access 2003 ListBox change row font color based on value

Larry Brister
Larry Brister used Ask the Experts™
on
I have a listbox that is returning my data and Column(1) value will be a "x" or nothing

Is there a way in VBA to change the entire row font color based on it's column(1) value = "x" ?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solution Only
Nerd
Most Valuable Expert 2012
Top Expert 2013
Commented:
Listboxes don't have that kind of formatting flexibility in Access.

If you need effects like that, an alternative is to use a subform in continuous forms or datasheet view and apply conditional formatting.
Jim HornSQL Server Data Dude
Most Valuable Expert 2013
Author of the Year 2015

Commented:
^^^ what she said
Larry Bristersr. Developer

Author

Commented:
Thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial