Access 2007 - Hiding the Menu Bar

[Jim Franklin]

Hi,

This is driving me nuts so if anyone can help it would be very much
appreciated!!

I have a .mdb application that I developed in Access 2003 which is going to
be used by a client running Access 2007 run-time. When I load the mdb in
Access 2007, whatever I do, I cannot get rid of the menu bar at the top.
Ideally I want my startup form to load, maximise and show NO toolbars
whatsoever (although in 2003 I added a custom menu bar JUBMenu1 and a custom
shortcut menu JUBPopup1, so it could just show JUBMenu1 if that is easier.)

In Access 2007, I have gone into Access Options > Current Database and
unticked all the 'Allow Full Menus', 'Allow Default Shortcut Menus' and
'Allow Built-in toolbars'. I have tried setting the Menu Bar and Shortcut
Menu bar settings to either 'default' or to JUBMenu1 and JUBPopup1. Ribbon
Name is blank.

I have also tried in my form load event to run
docmd.showtoolbars "Menu Bar", acToolBarNo

I have tried setting the menu bar and shortcut menu bar properties for my
startup form to Blank/No or the JUB menus I mentioned.

Nothing makes any difference. The Menu Bar still appears, regardless of
whether my custom menu appears or not. I can undock it and move it, but I
cannot hide it.

Please can anyone help? Thanks!

Jim

 

[Damon Heron]

Your configuration is almost exactly the same as mine, except I don't have
the 07 menu bar appear (except for a brief appearance on opening, along with
the status bar). It then disappears.

Is your db saved in 2003 format?
Also, I noticed that I have Allow full menus checked.
Ribbon is blank, and menubar is set to the menu I designed in 2003.

It works for me!

Damon

 

[Jack D. Leach]

Hi,

This is driving me nuts so if anyone can help it would be very much
appreciated!!

I have a .mdb application that I developed in Access 2003 which is
going to be used by a client running Access 2007 run-time. When I load
the mdb in Access 2007, whatever I do, I cannot get rid of the menu
bar at the top. Ideally I want my startup form to load, maximise and
show NO toolbars whatsoever (although in 2003 I added a custom menu
bar JUBMenu1 and a custom shortcut menu JUBPopup1, so it could just
show JUBMenu1 if that is easier.)

In Access 2007, I have gone into Access Options > Current Database and
unticked all the 'Allow Full Menus', 'Allow Default Shortcut Menus'
and 'Allow Built-in toolbars'. I have tried setting the Menu Bar and
Shortcut Menu bar settings to either 'default' or to JUBMenu1 and
JUBPopup1. Ribbon Name is blank.

I have also tried in my form load event to run
docmd.showtoolbars "Menu Bar", acToolBarNo

I have tried setting the menu bar and shortcut menu bar properties for
my startup form to Blank/No or the JUB menus I mentioned.

Nothing makes any difference. The Menu Bar still appears, regardless
of whether my custom menu appears or not. I can undock it and move it,
but I cannot hide it.

Please can anyone help? Thanks!

Jim

With a reference to Microsoft Office 11.0 Object Library, use the
following line of code:

Application.Commandbars("Menu Bar").Visible = False

hth