I think this is probably something easy to do, but I have no clue.  I want the color of a field to change if the field contains "Retired" from a picklist.  This is for the Satus field on the Account Detail Form.  

I know how to do this with Check Boxes :

Sub chkCODClick(Sender)

    If Sender.Checked Then

      lblCOD.Color = clyellow

    Else

       lblCOD.Color = clBtnFace

    End If

End Sub

But I don't know how for this scenario.  I would really appreciate someone pointing me in the right direction.  Thank you

Pretty much the same as before - on the OnChange event for the form just add:

Select Case ebYourObject.Text
Case "Retired"
  ebYourObject.Color = vbRed
Case Else
  ebYourObject.Color = clWindow
End Select

Using a case statement simply means you can use more options later - you can use if/else if you want.

Thank you very much!  I got it working like a charm