Access 2010 Form Hide/show button help

accessnewbie

New member
Local time
2:16 PM
Messages
2
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 Computer

OS
windows 7 32bit
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 Computer

Computer type
PC/Desktop
Computer Manufacturer/Model Number
Custom built
OS
Win7-64
CPU
Intel i7-3770S
Motherboard
ASUS P8Z77-M
Memory
16GB
Graphics Card(s)
nVidia GT630
Sound Card
onboard
Monitor(s) Displays
dual
Screen Resolution
1920x1200 (primary) 1050x1680 (secondary)
Hard Drives
128GB SSD (boot)
64GB SSD (Temp/My Documents)
500GB (photos/videos)
1TB (rendered video, backups)
PSU
650W
Case
Thermaltake A30
Cooling
Thermaltake
Keyboard
Logitech Lighted
Mouse
Kensington Expert Mouse (trackball)
Internet Speed
FIOS 35/35
Antivirus
MS Security Essentials
Browser
Chrome (beta)
Back
Top