How to hide Menu Bar in reports

J

John Reichard

I have created a database with custom menu bars. When I
open reports, the custom menu bar appears, but so does
the built-in Menu Bar showing File, Window, and Help. I
can't seem to find a way to hide the Menu Bar. Does
anyone have a solution? All my forms just show the
custom menu bar, but it doesn't seem to work for
reports. Thanks for your help.

John
 
F

fredg

I have created a database with custom menu bars. When I
open reports, the custom menu bar appears, but so does
the built-in Menu Bar showing File, Window, and Help. I
can't seem to find a way to hide the Menu Bar. Does
anyone have a solution? All my forms just show the
custom menu bar, but it doesn't seem to work for
reports. Thanks for your help.

John
Click to expand...

In the Open event of each report:
DoCmd.ShowToolbar "Menu Bar", acToolbarNo

In the Close Event of each report:
DoCmd.ShowToolbar "Menu Bar", acToolbarYes
or..
DoCmd.ShowToolbar "Menu Bar", acToolbarWhereApprop
 
A

Albert D. Kallal

You should be able to get this to work with NO code.

Try downloading and running the 3rd example here:

http://www.attcanada.net/~kallal.msn/msaccess/DownLoad.htm

The above example hides all of the ms-access menus. It is also has a sample
report that runs, and has its own custom menu bar, and that is the ONLY menu
that shows. (you just specify the menu bar for the reports the "other" tab).
All of the settings to accomplish this whole setup are in tools->startup,
and it took NOT one line of code to hide, or setup the menus


Give the above sample a try, and even run the report to see how well it
works.
 
J

John Reichard

Albert:

It worked like a charm. I think the main thing I had
wrong was that I had Allow Full Menus unchecked and Allow
Default Shortcut Menus checked, which was the opposite to
what you had. I then added the custom menu to the report
properties and just like that, the built-in menu was
gone. Thanks! Sometimes it's just the little things
that get overlooked and it just takes a fresh set of eyes
to see what's wrong.

John
 
Top