I am trying to make these changes on AXFormChange.  The font size is changing correctly.  But not the other 2.  A little help with the correct syntax.

Thanks ahead of time.

If chkVIP.State = cbChecked Then

    chkVIP.Color = clBtnHighlight

    chkVIP.Font.Size = 14

    chkVIP.FontColor = clRed

 Else

    chkVIP.Color = clBtnFace

    chkVIP.Font.Size = 8

    chkVIP.FontColor = clBtnText

End If

I've never been able to go that deep into the object at runtime......if someone has the answer I'm all ears!

Try adding a button to the form. On it's click event do the above - see if it's actually the axFormChange that's the issue - as the .Color and .FontColor are correct. Also, to be sure, instead of using constants use :

chkVIP.Color = Application.BasicFunctions.StringToColor "Red"

I tried using a button and the Application.BasicFunction neither worked.  I guess the Font Size will have to be enough to make it stand out.  If anyone has any other ideas it would be greatly appreciated.

Thank you,

Michael.

Quote: Originally posted by Mike Spragg Try adding a button to the form. On it's click event do the above - see if it's actually the axFormChange that's the issue - as the .Color and .FontColor are correct. Also, to be sure, instead of using constants use : chkVIP.Color = Application.BasicFunctions.StringToColor "Red"