list box colours?

Hello,

At the moment i have a list box which is populated with information from an access database. Each line in the list box is a report, each report has a status, complete = green, half-complete = yellow and red for not complete.
I was wandering if anyone knew how i could set each line which makes up the listbox the colour of its status (the colour of the line is determined in a field in the database)?
I can query the database to find the colour of the report but I can’t set the colour of the line to whatever the colour is.

Any ideas?

not any easy task, you're going to need to use fairly advanced programming techniques to achieve it. if you really want to try and do it, do some research on sub-classing.