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