>I have a list box which is populated by a cursor. The cursor has 2 fields namely Design Ref & Status. If I run my form I will see the following in the list box:
>
>

>JKT001        Pending Release
>JKT002        Submitted
>TR002         Pending Release
>

>
>What I would like to do is if the status is Pending Release then I want those items in the list box to be Yellow and if the status is Submitted I want is set to red.
>
>Is this possible?
>
>I have created the query with something like the following but this just shows them all as red!!
>
>

>WITH thisform.pageframe1.page5.list1
>	.ItemForeColor=IIF(curlist.fabstatus='Pending Release',RGB(255,0,0),RGB(128,128,128))
>	.rowsourcetype=2
>	.rowsource='curlist'
>ENDWITH
>

Neil:

Why not use a grid control instead of a ListBox? It makes it much easier to control colors like you want.

You can make the grid look like a ListBox if you take out the grid lines. You can control color dynamically with DynamicBackColor/DynamicGridColor (see examples in grid's help)