Not at my computer at the moment but its easy enough to do if using A2010 or later.
See the HideRibbon function in this example app http://www.mendipdatasystems.co.uk/c...ace/4594365418
Run that function from an autoexec macro at start up.
UPDATE: Back at my PC now:
Code:
Public Function HideRibbon()
DoCmd.ShowToolbar "Ribbon", acToolbarNo
End Function
NOTE: This also hides the QAT which makes printing reports tricky.
I handle that by displaying the Print Preview ribbon when a report is opened and hiding the ribbon again when the report is closed.
The example app includes an example showing how that's done