 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / September 2007Hiding/Unhiding a text box
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! 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  SignatureAllen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html 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! 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") [quoted text clipped - 4 lines] > >have > > set as not visible to become visible. Should be simple but isn't! 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 > [quoted text clipped - 6 lines] > > >have > > > set as not visible to become visible. Should be simple but isn't! Thanks Allen it works perfectly > Replace the label with a text box bound to an expression like this: > =IIf([MyYN], Null, "Say what") [quoted text clipped - 4 lines] > >have > > set as not visible to become visible. Should be simple but isn't! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.