|09 Jun 2012||#1|
Access 2010 Form Hide/show button help
I have client fields that are – client’s first name, client’s last name, their street address, suburb and city, their landline number and their cell phone number and their email address.
I don't always want to see the email address and would like to have a button that will show or hide the email address.
I need to write a set of instructions that will help solve this
Been trying everything and cant find a method to solve this, been using access 2010 complete book and internet
|My System Specs|
|12 Jun 2012||#2|
This is not a difficult one to do. Start by determining whether most of the time you want the field to be visible or not. Suppose you want it to be usually visible. Then let it's Visible property stay at the default value which is True.
Create you rbutton that controls the visibility of the field. Then in its Click event simply set the Visible property to false. Here's a sample of what the code should look like:
If Me.PeopleType.Text = "CASLA" Then
allusl.Visible = False: labelusl.Visible = False: uslbox.Visible = False
Label220.caption = "Display records of type:"
Me.CASLAType.Visible = True: Label220.Visible = True
The above code sets several things invisible and several other things visible. But you should get the idea how to adapt the code for your purposes.
|My System Specs|
|Similar help and support threads for2: Access 2010 Form Hide/show button help|
|Windows Font size for Tab Control /button caption or form too Small||Customization|
|Enable Print Preview button only in Access 2010||Microsoft Office|
|Access 2007:Form Design Grid not showing||Microsoft Office|
|Chrome gives the option to hide any extension button?||Browsers & Mail|
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd
All times are GMT -5. The time now is 07:20 AM.