Combobox display rows colour problem

[KneeDown2Up]

Is it possible to have certain rows highlighted in a different colour, based
on the value of a field in the respective table?

I have a form with a no. of cbo boxes on it, in each box I would like to be
able to show the status of the record (via a yes/no field) from the same
table. I can change the colour of all the fields but not the one that carries
the identifier.

I have this so far....

Select Case Me.Cbo1.Column(6)
Case Is = 0
Me.Cbo1.ForeColor = vbRed
Case Is = -1
Me.Cbo1.ForeColor = vbBlue
End Select

But as I've said, if the row I select meets the criteria, all fields
displayed change colour.

Any help very much aprreciated.

Thanks