Hiding a Button on the menu form

Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.Sc
Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.Sc used Ask the Experts™
I have created a form menu in my application which has buttons created where people are able to choose where to go , but they are created using the macro wizard not VBA.

(1) Is it possible to hide  these buttons , for example , the objective here is that there some button which are allocated to administrators, accountants , managers  and data entries clerks , I want my form to show only those buttons  relating to user rights. For example the current application does not allow anyone to use all the buttons unless one is not a data entry clerk.

(2) I was also thinking of ways of creating drop downs menus  instead of buttons is it possible in access? I do not to use access built switchboard , it is not okay for huge projects


Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
ste5anSenior Developer

What Access version? What project type? Cause I prefer using the Ribbon for that.

And why have you tagged your post Golang? This is the Go programming language from Google..
President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012
<<(1) Is it possible to hide  these buttons >>

  Yes.  Generally you would do this in the OnLoad event of the form.

<<(2) I was also thinking of ways of creating drop downs menus  instead of buttons is it possible in access?>>

 With later versions you are stuck with the ribbon and yes, you can create your own.   This is the best site for things related to that:


Lots of good info there and the tool, but you will be moving into using VBA.  And I would suggest that your learn VBA.  Working with Macro's is difficult.

There's also this article, which is a general overview of the ribbon and how to use it:


Thank you so much at least I have now somewhere to start

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial