I'm trying to get the following If statement to work in a report:
I can't get a valid "If" statement. I keep getting "You entered an expression that has no value."
What is the proper way to check an "if" statement against a check box?
Thanks,
Code:
Private Sub Report_Open(Cancel As Integer)
If Me.ChkPerm = Yes Then
Me.txtBOX.BorderColor = 16711680
Else
Me.txtBOX.BorderColor = 10711680
End If
End Sub
I can't get a valid "If" statement. I keep getting "You entered an expression that has no value."
What is the proper way to check an "if" statement against a check box?
Thanks,