Don't want menu bar

P

Phillip

Hi,
I have a form with a command button that opens a report with the following
command:

DoCmd.OpenReport stDocName, acViewPreview

The reports opens and has the menu bar. Is there a way to prevent the menu
bar from showing? If I go to design view and select view/toolbars/customize
the menu bar is checked, but I can't uncheck it.
Your help would be appreciated.
Thanks
Phil
 
A

Arvin Meyer [MVP]

HideMenu:
DoCmd.ShowToolBar "Menu Bar", acToolbarNo

ShowMenu:
DoCmd.ShowToolBar "Menu Bar", acToolbarYes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How Do I Restore Menu Bar Toolbar 2
Standard Menu Bar has disappeared 1
Menu Bar hidden 1
change report using VBA, then view and close it 6
Hide Menu Bar 1
Hiding access window in Access 2003 2
deleted a custom menu bar, now getting macro error 3
Menu Bar 3

Top