G
Guest
Hi. I have a tiny form with a label acting as a command button. I want to be
able to change the Back Colour of the label dependant on content/no content
of another field on the form. I'm trying the following code, which doesn't
work. What am I doing wrong?
Private Sub Form_Current()
If Not IsNull(txtConfidentialNotes) Then
Me.lblConfidentialNotes.BackColour = 5878528
Else
Me.lblConfidentialNotes.BackColour = 12632256
End If
End Sub
Thanks JohnB
able to change the Back Colour of the label dependant on content/no content
of another field on the form. I'm trying the following code, which doesn't
work. What am I doing wrong?
Private Sub Form_Current()
If Not IsNull(txtConfidentialNotes) Then
Me.lblConfidentialNotes.BackColour = 5878528
Else
Me.lblConfidentialNotes.BackColour = 12632256
End If
End Sub
Thanks JohnB