Conditional Formatting of a Label

[rmilsley]

In an Access 2010 form, I want to trigger a change of visibility of a label, when it's corresponding checkbox is selected. In other words, if No, the Label is not visible, if yes, the label is visible

[RuralGuy]

You would do that in the Click Event of the Checkbox.

[rmilsley]

How do I do that?

Many Thanks

[RuralGuy]

This would go in the Click Event code window.

Private Sub YourCheckBoxName_Click()
   If Me.YourCheckBoxName Then
      Me.YourCheckBoxLabelName.Visible = True
   Else
      Me.YourCheckBoxLabelName.Visible = False
   End If
   
End Sub

...replacing the highlighted values with your values of course.

[rmilsley]

Many Thanks

[RuralGuy]

You're welcome. Glad we could help.