Hide default menu for Print Preview

[Guest]

I've created a customer menu and toolbar to appear when a particular report
is i the print preview mode. The problem is not only does the custom menu
appear, but also the default menu.

This is the only point where I want to use a custom menu so I don't want to
disable the standard menus at startup. It would be great to either hide or
disable the default menu when this report is in the print preview mode and
have the standard menus activated when one exits or closes the report.

Any help with this would be appreciated.

 

[Guest]

The command to do this is
DoCmd.ShowToolbar "Print Preview", acToolbarNo
You can put this in the report's OnLoad event.
To show it, change the code to ...acToolbarYes.

Other useful toolbar show/hide commands:
DoCmd.ShowToolbar "Formatting (Form/Report)", acToolbarNo

DoCmd.ShowToolbar "Form View", acToolbarNo

DoCmd.ShowToolbar "Database", acToolbarNo

DoCmd.ShowToolbar "Menu Bar", acToolbarNo

 

[Guest]

Thanks for your suggestion. It was very helpful, but "Print Preview" is a
toolbar rather than a menu. I had already gotten ride of the toolbar. But
the command
"DoCmd.ShowToolbar "Menu Bar", acToolbarNo " did the trick.

 

[Guest]

Ok, Came here to find out why my menu bar in my report's print preview has
gone. I tried the things you suggesed, in the OnOpen Event (I couldn't find
OnLoad). This does not solve it, and I've looked through all the reports
properties to find out how to get it back in. Please help.