I think this is probably something easy to do, but I have no clue. I want the color of a SalesLogix 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 :
If Sender.Checked Then
lblCOD.Color = clyellow
lblCOD.Color = clBtnFace
However, I don’t know how to accomplish this for a picklist object.
On the OnChange event for the form just add:
Select Case ebYourObject.Text
ebYourObject.Color = vbRed
ebYourObject.Color = clWindow
Using a case statement simply means you can use more options later – you can use if/else if you want.