in a form, How to hide some buttons on the menu

[Martin]

in a form, How to hide some buttons on the menu. (Using VBA method or non
VBA method)

However, I don't want to hide these buttons in other forms.


How to do this?

Thanks!

Martin

 

[Van T. Dinh]

Which Menu?

The Standard MenuBar or ToolBar or your Custom Toolbar or a Form that you
use as a Menu Form?

You need to describe in more details which Menu/buttons you are referring
to.

HTH
Van T. Dinh
MVP (Access)

 

[Martin]

Just in the upper area of the access

Which Menu?

The Standard MenuBar or ToolBar or your Custom Toolbar or a Form that you
use as a Menu Form?

You need to describe in more details which Menu/buttons you are referring
to.

HTH
Van T. Dinh
MVP (Access)

 

[Van T. Dinh]

????

Which buttons / commands in the "upper area of Access"? Name them

HTH
Van T. Dinh
MVP (Access)

 

[Martin]

The button bar of the "form view"

????

Which buttons / commands in the "upper area of Access"? Name them

HTH
Van T. Dinh
MVP (Access)

 

[Van T. Dinh]

That's called the "Form View" ToolBar.

All you need to do is to right-click blank space somewhere on a ToolBar
(including MenuBar) and you can see the name of the visible ToolBars.

To see the name of all ToolBars, right-click as above and select "Customize
...."

To hide a Control on the "Form View" ToolBar, use:

Application.CommandBars("Form View").Controls(1).Visible=False

Change the Control Index to suit your requirements.

Make sure you reset it back when the database is closed so that the use can
use other databases without being affected by your database. Hence, it is
normal practive to create a Custom ToolBar (with reduced number of Controls)
rather than modify the standard ToolBars.