Invisible Label issue

[Sue Compelling]

Hi

I have an unbound control box which is populated by a query checking to see
if a check box has been ticked.

If the check box is ticked (and therefore the control shows as "yes") then I
want my label to become visible ...

I have tried various iterations of the below - though no matter what I try,
the label always stays visble or always stays invisible.

Hoping you can help ...

Me.SelfLabel.Visible = Not IsNull(Me.Self)

Or

If Me.Self= "yes" Then (or I put in 0 or -1 or 1 or
false etc)
Me.SelfLabel.Visible = False
Else
Me.SelfLabel.Visible = True
End If

... Sue Compelling

 

[Sue Compelling]

Hi Benjamin

Thanks for the prompt reply - this makes the label invisible all the time
(regardless of whether the control says yes, no or has no value)

Anything other options?