Color Coding in List Box

[pgk]

Hi,
I would like to display the rows of a list box in different colors. The situation is this:

The list box is a multi column, no multi-select one.
Column 8 of the list box will contain either "Emergency" or "Routine". If it is "Emergency", I would like to display that row in say Red color. Otherwise, it should be displayed in White color.

The data for this list box is from a table and the particular field in that table that populates Column 8 of the list box is a Text field.

Any help in this regard would be very much appreciated. Thanks a lot in advance.
With regards,
PGK

 

[pgk]

Hi Folks,
Is there some way to accomplish what I want ( described in the above post )? Any suggestions would be welcome. Thank you in advance.
With regards,
PGK

 

[JPeters]

Sure .... I have a copy of a Database that shows you how to set continuous view form records to different colors based on different criteria. Just email me and I'll send it to you. My email is down there. Lonnie Johnson get's the credit for this database, he wrote it, not me.

-Josh ------------------
-JPeters
Got a helpful tip for Access Users? Check out and contribute to 'How to Keep Your Databases from becoming Overwhelming!'
thread181-293590
jpeters@guidemail.com
------------------