As you all know, the latest version of MS Office no longer has toolbars. Instead, there is the fancy Ribbon, which you either love or hate according to the mail I receive from my readers. Some folks love it because they think it is easier to use and more intuitive than earlier versions. Other folks hate it because it is so gosh-darned permanent! Simply put, you cannot customize the Ribbon like you could the toolbars of yore.
Unfortunately for developers, the Ribbon object is not as easy to control as was the command bar object of days gone by. MS Access developers can show and hide the Ribbon programatically, using the commands below:
DoCmd.ShowToolbar “Ribbon”, acToolbarNo
DoCmd.Showtoolbar “Ribbon”, acToolbarYes