[AccessD] How To Make All Controls on a Form Invisible

Jim Dettman jimdettman at verizon.net
Fri Mar 29 16:25:32 CDT 2013


  You can do it by section:

   Me.Detail0.Visible = False

 Otherwise, you'll need to loop through the forms control collection.

Jim.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Friday, March 29, 2013 04:59 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] How To Make All Controls on a Form Invisible

All,

We have an Access 2007 application that has a form which contains many
controls (buttons).

This application is now going to be placed on a PC where the user is
only suppose to see only 1 button.

Is there an easy way in VBA to make all buttons on the form invisible.
(This would be followed by a single line of code to make the single
button visible for this specific user.)

Thanks,
Brad



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list