list box - changing row text color?

[jatfill]

Hi all,
I was wondering if anyone knows how to write a property that changes a row color inside a list box based on a value within that specific row.

What I have is a list of overdue orders on a form, the user can print the entire list (the report displays orders which are overdue by >13 days in red with no problem). Or, they can double click an entry to open the order in question.

This isn't an absolute need, but I'm a big fan of visual cues, so I would like to set up the list box to display the order information in red only where [Elapsed] > 13

Thanks in advance for any help you can offer... let me know if I need to clarify at all.

[This message has been edited by jatfill (edited 08-02-2001).]

 

[jstutz]

I'm not aware of anyway to do this with a Listbox. However, Mike Gurman recently posted a response to a similar question about conditional formatting of a form which you might find helpful... see:
http://www.access-programmers.co.uk/ubb/Forum4/HTML/003719.html

Perhaps you could build a subform using the cond. formatting Mike suggests and use it like a list box. If his demo file is no longer at the posted link, let me know and I can email it to you.

Jamie