Using checkbox to change font

[James Mitchell]

Have check box Labled "Fail" would like this to change
either the check mark of the lable to red if "True". How
do I do theis in VBA I'm assuining an If, Then statment
that would change font.color for the checkbox label
property. Do not know how to do this exactly. Any help
appreciated

 

[fredg]

Have check box Labled "Fail" would like this to change
either the check mark of the lable to red if "True". How
do I do theis in VBA I'm assuining an If, Then statment
that would change font.color for the checkbox label
property. Do not know how to do this exactly. Any help
appreciated

In the Check Box AfterUpdate event AND in the Form's Current event:

If Me![CheckBoxName] = True Then
Me!LabelName.ForeColor = vbRed
Else
Me!LabelName.ForeColor = vbBlack
End if

Change the label name and check box field name to whatever the actual
names are.