DoCmd.ShowToolbar "Ribbon", acToolbarNo
DoCmd.ShowToolbar "Ribbon", acToolbarYesMost likely, you'll hide the Ribbon when you launch the database using an AutoExec macro or startup property. You could add a custom button that shows the Ribbon or simply hide and show the Ribbon as required. Excel users can use a similarly easy set of VBA statements to hide and display the Ribbon, respectively:
How you execute the code is up to you. You can attach the hide code to ThisWorksheet's Open event to hide the Ribbon when a user opens the file. Or you might execute it when you launch a user form.
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.