Hiding the Ribbon in Access 2010

[osera]

Good morning,

I have an Access 2010 database with a couple of forms that allow my users to select from a group of comman buttons. Unfortunately, a good number of my users insist on setting their screen resolution to 800x600 which results in the ribbon covering up the top portion of the form.

In another post, I saw a reference to a vba command that will hide the ribbon but there wasn't a link to the command. Does this code exist? If so, can someone share it here?

As always, my thanks for your assistance.

 

[PHV]

I'd try this:

DoCmd.ShowToolbar "Ribbon", acToolbarNo

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[osera]

That worked, PHV, but a little too well. It not only closed the ribbon, but also the menu bar and the quick access toolbar at the top of the screen. Are they all considered to be one as the ribbon?

Perhaps I'm asking the wrong question. Maybe I'm looking for a way to minimize the ribbon instead of hiding it completely. Is that possible?

 

[PHV]

And this (ac2010 only) ?
CommandBars.ExecuteMso "MinimizeRibbon"


Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[osera]

Perfect! Thanks again!