Access97 - Remove Menus in Print Preview

[SHardy]

I have an Access97 app, in which I have hidden the standard menu & toolbars. I have a custom menubar that is used throughout.

However, I have only just noticed a potential problem. In the app, it is sometimes necessary to print preview reports. When in the print preview screen, another menu is shown which has the File, Window and Help menus, along with the minimize, restore and close buttons.

I understand why this is shown, as it needs a way of closing the report, without closing the app.

Is there a way of removing/ hiding this menu bar and either:

1)Adding the close (x) button to my custom menu bar?
2)Showing a blank menu bar which just has the min, restore & close buttons?

Thanks,
Simon

 

[ZmrAbdulla]

Create another custom menubar and assign it to the report
for more on this see the tutorial
regards


Zameer Abdulla
Visit Me
Where to pay your [purple]Tsunami[/purple] relief donations?

 

[SHardy]

Sorry, I think I am having a dum day. The answer to my question would have been to edit the "startup" options to use the custom menubar as the app's main menubar.

This then would prevent the other menu items appearing.

I would have realised this if I had actually set the custom bar as a menubar, rather than as a toolbar.

So...

Now I have a custom MENUBAR, and have set this within the startup options. No other menu options appear, other than those within my custom menubar.

However, I have a blank menubar that is always at the top of the screen. This is a non-moveable bar with absolutely nothing on it. No menu items and no re-sizing/ close buttons.

I am assuming that, even though I have set the app to hide the default menu, this is a place holder for the default menubar.

Is this correct?

Can I prevent this? I would rather the blank bar wasn't there. It just doesn't look right. My custom menubar should be at the top of the screen, directly under the blue title bar. Not half an inch below with blank space between.

Any help would be greatly appreciated.

 

[ZmrAbdulla]

You can set
[Blue]PupUp=Yes
Modal=Yes
Min Max Buttons= None
Close Button = Yes/No << This is up to you
[/blue]
Again...
If you right click on the report default menu will appear. Prevent this by creating a custom Shortcut Menu.
Also you can prevent a custome Menu/Toolbar from appearing
On Open Event
[tt]DoCmd.ShowToolbar "YourMenubarName", acToolbarNo
[/tt]or
[tt]DoCmd.ShowToolbar "YourMenubarName", acToolbarYes
[/tt]to appear
Normally I assign a Tool/Menubar and hide it by code so I can hide both default and custom
Hope this helps

Zameer Abdulla
Visit Me
Where to pay your [purple]Tsunami[/purple] relief donations?

 

[SHardy]

I have the menus as I want them to appear now, with the exception that I seem to have this blank placeholder for the default menubar "Menu Bar". There is nothing selectable on the bar. It is completely blank. However, I would rather that it wasn't there at all. Any ideas on how to get rid?

 

[SHardy]

I have got to the bottom of this now.

Sorry, I should explain that this was an app that was previous "developed" by my predecessor. I have just found that in the properties for every form he had set the "Menu Bar" property to "=1" for some unknown reason. Removing this also removes this blank menubar.

Thanks for your time and help,
Simon