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

If you want to hide ALL the controls of a particular type, then TypeOf is
your friend.  If you want specific controls hidden, you'll need to use the
control names.

Charlotte


On Fri, Mar 29, 2013 at 1:59 PM, Brad Marks <BradM at blackforestltd.com>wrote:

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