Making a toggle button hide a text box.

[RemonKoybito]

Hello everyone, and thanks for reading. I've never worked with access before but I just got an internship and I'm going to be in charge of revamping the client database. I bought a step-by-step access book, so I know the basics, but I still need help.

My boss wants our new forms to have a text box that can be hidden, to put notes about problems we've had with clients. They can't see it since the forms are going to be filled out with the client sitting next to us. It also needs to be super simple, since this is a nonprofit and volunteers are going to be filling it out most of the time.

I've done some reading about check boxes hiding text, but I want a larger button so it's easier to read. In what I've read you need to bind the button with the text box so it toggles it being visible or not. How do I do this? And then what code or macro or whatever would I use on the buttons click?



I named the button "ToggleButton" and the text box "SecretClientInfo".

Thanks so much!

[pbaldy]

You can use this technique:

http://www.baldyweb.com/ConditionalVisibility.htm

A toggle button has a value of True or False (-1/0).

[RemonKoybito]

Oh my gosh, thank you! I can't believe it was so easy. You're an all star!

[pbaldy]

Happy to help, and welcome to the site!