List box font color

[Guest]

I have a List Box with row source from Projects

SELECT projects.ID, projects.project_name, projects.status FROM projects
WHERE (((projects.task_area)=Forms!check_status_1!role));

'role' is a combo box which value change causes List Box to requery. Anyway,
I would like font color in List Box to show red when 'status' in project
table is 'completed'. Is there way to do this?

 

[Guest]

You might want to check out Steve Leban's web site
(http://www.lebans.com/List_Combo.htm). He has done some awesome things with
listboxes.