Code to change label colour

  • Thread starter Thread starter Tony Williams
  • Start date Start date
T

Tony Williams

I want a label control of a tickbox on a form to change colour if it is
checked, assuming the checked value is YES. I've tried this code but it
doesn't work

Private Sub txtwithdrawn_AfterUpdate()
If Me.txtwithdrawn Is Yes Then
Me.txtwithdrawn_Label.ForeColor = 255
End If
End Sub

Can anyone help me here.
Thanks
Tony
 
Sorry for posting too swiftly, realised that checked value should be = True
and it worked.
Thanks
Tony
 
Back
Top