List Box Conditional Format

[steinfeld]

I have a listbox on a form. It has 2 columns. They contain the info below:

Event1 Pass
Event2 Fail
Event3 N/A
Event4 Pass

I would like to highlight the word Pass in green and Fail in red. Is there any way to do this in a listbox.

 

[RoyVidar]

That can't be done with native Access listboxes. I think this might be achieved using listviews, but I don't use them, so I wouldn't know for sure. Do check out the faq section of this forum, though, as the member ZmrAbdullah has made a couple of faqs on the topic.

Roy-Vidar

 

[TheAceMan1]

How are ya steinfeld . . .

You can [blue]make a subform look just like a listbox[/blue], availing you the power of [purple]Conditional Formatting[/purple]!

See Ya! . . . . . .

 

[steinfeld]

Ok. What controls would you use. A form that dynamically adds labels?

 

[RoyVidar]

If you've ruled our suggestions (listview and subform) out, I wouldn't know what else to suggest.

Roy-Vidar

 

[steinfeld]

None ruled out. I should have said which controls would you use on your subform. I am interested in doing this because it is like makeing your own custom control in a way. But what would you use in the sub form. Lables?

 

[RoyVidar]

Conditional formatting works on text controls and combos, I think, not labels, so to me, that rules lables out ;-)

Roy-Vidar