Using checkbox to change font

J

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
 
F

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
Click to expand...

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.
 
Top