Hiding/Unhiding a text box

[Guest]

I have a check box. When I click it making it True/Yes I want a label I have
set as not visible to become visible. Should be simple but isn't!

 

[Allen Browne]

Replace the label with a text box bound to an expression like this:
=IIf([MyYN], Null, "Say what")

Use your yes/no field name instead of MyYN

 

[Guest]

Thank you, I will give that a go

Replace the label with a text box bound to an expression like this:
=IIf([MyYN], Null, "Say what")

Use your yes/no field name instead of MyYN

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I have a check box. When I click it making it True/Yes I want a label I
have
set as not visible to become visible. Should be simple but isn't!

 

[Guest]

Thanks Allen it works perfectly

Replace the label with a text box bound to an expression like this:
=IIf([MyYN], Null, "Say what")

Use your yes/no field name instead of MyYN

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I have a check box. When I click it making it True/Yes I want a label I
have
set as not visible to become visible. Should be simple but isn't!

 

[Guest]

The title of the question says Text Box, but the question text says label.
Assuming you really meant label, and that you don't want the user to be able
to edit it, you can do it like

Private Sub chk_Box_Click()
Me.lbl_ImClicked.Visible = (Me.chk_Box = True)
End Sub

The visibility of the label will follow the status of the check box.

Thank you, I will give that a go

Replace the label with a text box bound to an expression like this:
=IIf([MyYN], Null, "Say what")

Use your yes/no field name instead of MyYN

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I have a check box. When I click it making it True/Yes I want a label I
have
set as not visible to become visible. Should be simple but isn't!