MS-Access 2007 Minimize/Maximize Ribbon

[JimP]

Is there a call to minimixe or maximize the ribbon when a form or report
opens?

 

[Dirk Goldgar]

Is there a call to minimixe or maximize the ribbon when a form or report
opens?

You can *hide* the ribbon using:

DoCmd.ShowToolbar “Ribbon”, acToolbarNo

.... and show it again using:

DoCmd.ShowToolbar “Ribbon”, acToolbarYes

The only way I know of to *minimize* the ribbon programmatically is to use
SendKeys (which I normally avoid like the plague) to send the Ctrl+F1
combination:

SendKeys "^{F1}", True

This key combination is a toggle: if the ribbon is currently maximized, it
will minimize it; if it's currently minimized, it wil maximize it. It's
possible to check the current height of the ribbon to determine if it's
currently minimized or maximized. You can get the height from

Application.CommandBars.Item("Ribbon").Height

 

[JimP]

Thank you - I agree awith avoiding send keys - could make matters worse.