You Guys are awsome with your advice and assistance - thanks a lot.

When using the standard list box control - Is there any way to have rows of
data appear in different colour based on certain criteria:

Example:
I have a list box based on a query that has a few data points one of which
is DispCode - based on the value of DispCode can I get the row in the list
box to show up as a colour that I can set?

I dont think this is possible with the standard MSAccess Listbox Control but
I thought I would ask anyway and to see if anyone had any suggestions for a
different control that might work for me.

Thanks all,

Jeff

You might be able to get what you're trying to get by using a subform with
Conditional Formatting rather than a list box.

I think that TList, from Bennet-Tec, can do what you want as well
http://www.bennet-tec.com/btproducts/tlist/tlist.htm

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Jeff" <(E-Mail Removed)> wrote in message
news:du59ru$5i4$(E-Mail Removed)...
> You Guys are awsome with your advice and assistance - thanks a lot.
>
> When using the standard list box control - Is there any way to have rows
> of
> data appear in different colour based on certain criteria:
>
> Example:
> I have a list box based on a query that has a few data points one of which
> is DispCode - based on the value of DispCode can I get the row in the list
> box to show up as a colour that I can set?
>
> I dont think this is possible with the standard MSAccess Listbox Control
> but
> I thought I would ask anyway and to see if anyone had any suggestions for
> a
> different control that might work for me.
>
> Thanks all,
>
> Jeff
>
>