Turning of the Menu Bar 1

[GreenFella]

Is there anyway to turn the default Menu Bar off in an Access application?

More screen real estate is required for an app and I would like to be able to free some up by turning off the Menu Bar.

TIA.

GreenFella.

 

[Ed2020]

This should do the trick:

Application.CommandBars("menu bar&quot.Visible = False
Application.CommandBars("menu bar&quot.Enabled = False

Ed Metcalfe.

 

[Haitham]

It's more easy for you to 4get the Coding and do this,,,
In Form Properety,,,,,Other,,,,,MenuBar
type =0

that set

Good Luck

 

[GreenFella]

Thanks for the tips guys.

When I tried the code approach it didn't like it to much. I got the error message:

Method Visible of CommandBar failed

I tried the =0 on the Menu Bar property and that worked for turning off the options on the Menu Bar. However, the space that the Menu Bar occupied is still taken up by a blank bar.

Which isn't what the end user was looking for but which will come in handy for something else that I am working on.

Thanks for your help Ed2020 and Haitham.

 

[bocker]

Try in On Open Event:

DoCmd.ShowToolbar "Menu Bar", acToolbarNo

If you need to get to design view, Hold Down the Shift Key while Opening.

 

[GreenFella]

Thanks bocker, that did the trick.

Greenfella