Hide Menu Bar

[TinleyParkILGal]

Help, I have created a tool bar for my database which I am having no problem
with now but I cannot hide the menu bar for this database. I uncheck it in
the customize box and then uncheck allow showing and hiding and I have tried
all kinds of combinations but it keeps coming back. This excerpt from help
says:

Setting
Enter the name of the menu bar you want to display. If you leave the MenuBar
property setting blank, Microsoft Access displays the built-in (default) menu
bar or the application's global menu bar. If you set the MenuBar property to
a value that is not the name of an existing menu bar or menu bar macro, the
form or report will not have a menu bar (the default menu bar will not be
shown).


I have tried this and have set the MenuBar property to both a number and a
character and nothing works. I get the error message "Cannot find macro
"number or digit".

 

[Albert D. Kallal]

The trick in hiding all of the menu bars is two things...

First, you must always use the shift-key by-pass when you are working on
this database...

Once in via the shift key by-pass, simply hide all of the tool bars, and
ONLY have the main ms-access menu showing.
(right click menu bar - customize).

You can then simply specify the main menu bar in the tools->startup..and
away you go...

So, any menu bars etc. that are showing when you shift by-pass into
ms-access will stay put, and thus simply hide them..and they will stay
hidden.

Try downloading and running the 3rd example at my following web site that
shows a hidden ms-access interface, and NO CODE is required to do
this....but just some settings in the start-up.

Check out:

http://www.members.shaw.ca/AlbertKallal/msaccess/DownLoad.htm

After you try the application, you can exit, and then re-load the
application, but hold down the shift key to by-pass the start-up options. If
want, you can even disable the shift key by pass. I have a sample mdb file
that will let you "set" the shift key bypass on any application you want.
You can get this at:

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

So, download and try that sample...as you can then take a look/compare your
settings in startup to this example...