Question Minimize navigation pane and upper tabs

[jleval]

Is there a way to minimize the navigation pane and the upper tabs on start up? I have several big forms that don't seem to fit unless these are minimized. Your help is greatly appreciated.

 

[mdlueck]

Here you go for the Navigation Pane detail...

"Minimize Navigation Pane in A2007"
http://www.access-programmers.co.uk/forums/showthread.php?p=1127715&posted=1#post1127713

 

[jleval]

Okay, this works for the navigation pane, but how about the ribbons or tabs in the top of access. Is there a way to minimize those as well

 

[exASHacto]

To hide tabs:
To go Access Options --> Current Database --> Remove the tick in "Display Document Tabs"

To hide the ribbon:
DoCmd.ShowToolbar "Ribbon", acToolbarNo

 

[mdlueck]

To hide tabs:
To go Access Options --> Current Database --> Remove the tick in "Display Document Tabs"

Just out of interest, there is no VBA way to perform this tweak?

 

[vbaInet]

You can hide/unhide the ribbon completely:

DoCmd.ShowToolar "Ribbon", acToolbarNo

There's a programmatic way of minimizing the ribbon using a couple of APIs but I can't find the code at the moment. I've not done anything Access in a long while. If I find it I will let you know.