>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,
FWIW use a grid instead.
Cetin