• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1768
  • Last Modified:

MS Access 2003 ListBox change row font color based on value

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" ?
1 Solution
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 HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
^^^ what she said
lrbristerAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now