Are you referring to this? Check Box Color

Where is the color coming in? What is your conditional formatting?

Yes I am, I used a toggle box with a No for use theme with A"P" and wingding 2 font.  A "P" in WingDing 2 font is a check mark.

It takes me 5 days to get money into my paypal account.  Be patient for the future.

What is the PayPal reference about?

You could do this with all VBA as well. Something like

Private Sub ToggleBtn_Click()
    If CheckBoxName = True Then
    ToggleBtn.BackColor = vbWhite
    ToggleBtn.ForeColor = vbRed
    ElseIf CheckBoxName = False Then
    ToggleBtn.PressedColor = vbWhite
    ToggleBtn.PressedForeColor = vbGreen
    End If
End Sub

Adam:

I will try your code.  I was told to switch to a forum for purchasers of that sort template.  So I thank you for your help.  I will continue to try my query and menu for sorts.  The other way.  I eventually will get it to work.  Thank you again.  The comment about PayPal deals with funding your tip jar.   I have to work on it.

Oh no worries, yea if you use that code in the click event and in the on current event of the form you should always have the colors you want.

Adam:

The code is below.  I believe the code is commonly known.  By publishing it here.  The tech help is free on the website.  

is two lines of code.  I modified it slightly.  Your code could be added.  I just don't know where to put it.  So I will work it in and see what happens.  Jeff

Private Sub Form_Current()
IsActive_AfterUpdate
End Sub

Private Sub IsActive_AfterUpdate()
If isACTIVE Then
isACTIVE.Caption = "RECORD IS ACTIVE"
Else
isACTIVE.Caption = "RECORD NOT ACTIVE"
End If

End Sub