MenuBar

[Frank H]

Can anybody assist ?
I want to prevent the menu bar from displaying for specific forms / reports
only.

According to Access help:

'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).'

If I set the menubar property to a non existent value, I get an error
message.

Is there another simple way to turn the menu bar off "

I have experimented with 'DoCmd.ShowToolbar "Menu Bar", acToolbarYes/No",
but this applies to the whole app, and I don't want this.

TIA

Frank H

 

[default105]

I have never done this for only a few forms because I usually apply it to the
whole database but couldn't you apply DoCmd.ShowToolbar with the Open and
Close events respectively

 

[Frank H]

Thanks for the reply, probably no real reason to not do it like that, cheers