VBA - Access 2007 Hide Ribbon

[CrazyKid]

Hi,

Please can anyone help with either the code or the registry key to allow me to hide the ribbon in Access 2007. I've searched the registry and found only the quick tool bar (which is not a problem) and all of the code related to hiding it, doesn't work.

Many Thanks

Crazy Kid

[CrazyKid]

As it turns out its a really easy answer.

Code:
DoCmd.ShowToolbar "Ribbon", acToolbarNo

If put in the form load of your master form, the Office 12 ribbon will hide itself.

I hope this helps others