Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can you hide the design view in the menu bar in access

Status
Not open for further replies.

jbanas

Programmer
Sep 18, 2007
18
US
I know how to hide the menu bar in access; but is it possible to hide certain options in the menu bar other than creating a new toolbar.

thanks

 
You could perhaps edit the existing menu with the commandbar object (maybe, it has been years since I looked at it). But then you are probably changing the default selections for Access.

I would use a custom toolbar. It is a lot less hassle than dealing with the commandbar object.
 
A crude way to disable ANY design view is to have an MDE.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
How are ya jbanas . . .

Which items are you intent on hiding? [blue]lameid[/blue] is on target with the [blue]Commandbar Object[/blue].

Example to hide the standard edit menu on the menubar:
Code:
[blue]   CommandBars("Menu Bar").Controls("Edit").Visible = False[/blue]
Example to hide [blue]Spelling[/blue] in the [blue]Tools Menu[/blue]:
Code:
[blue]   CommandBars("Menu Bar").Controls("Tools") _
                          .Controls("Spelling...").Visible = False[/blue]

Calvin.gif
See Ya! . . . . . .

Be sure to see thread181-473997
 
that is what i was going for aceman...appreciate it...thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top