Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Access 2010 Form Hide/show button help

09 Jun 2012   #1
accessnewbie

windows 7 32bit
 
 
Access 2010 Form Hide/show button help

Hi Guys

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

Thanks guys

Been trying everything and cant find a method to solve this, been using access 2010 complete book and internet

Mark


My System SpecsSystem Spec
.

12 Jun 2012   #2
bbinnard

Win7-64
 
 

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
End If

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 SpecsSystem Spec
Reply

 Access 2010 Form Hide/show button help




Thread Tools





Similar help and support threads
Thread Forum
Skype fails to show log-in form
After I accidently deleted few files from my computer I had to tragically system restore my PC, and the programs that were listed to be affected were Skype and Spotify, which is fine. After the System Restore, I re-installed Skype and this what happens (see image below) I uninstalled it then...
Software
Cant Access WIndows XP Machine form 7. Asks for a password [LAN]
hello, I am using Windows 7 64bit. I have another XP machine in my LAN. Windows 7 can see the Xp machine in the network tab. But when I try to access it, it prompts for a user name and password. I've tried setting up a password in my XP machine. Still when i try to connect to the xp machine...
Network & Sharing
Windows Font size for Tab Control /button caption or form too Small
I have no idea how it happened but the font type and size of all the captions of controls like tab, button, form text etc had changes and has gone too small. My window color and appereance is all set to size 9 Segoe UI. The Setting seems to have affected some windows and seems to not affect...
Customization
Enable Print Preview button only in Access 2010
I have disabled the quick access toolbar for the users in .accde file, so no toolbar appears when the Access 2010 application starts. When the users preview reports, I want to enable the print preview button only. How can I do this?
Microsoft Office
Access 2007:Form Design Grid not showing
If I open Access and double click on one of the forms I have created, and then click on Design view, the form is displayed. What I do not see is a grid of small dots behind the the form to assist in the design of the form. I know they can be summoned but I do not know how. Ken
Microsoft Office

Our Sites

Site Links

About Us

Find Us

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 18:50.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App