Access – Minimize/Maximize Navigation Pane/Shutter Bar
1/30/2019
2
Comments
2
Responses
Ever wanted to minimize/close the Navigation Pane/Shutter Bar? Not hide it completely, just make it minimize/close/collapse. Please share any code you have for this.
FMalik
October 16, 2019
December 30, 2021
If you want to hide navigation pane, use the following VBA:
DoCmd.NavigateTo "acNavigationCategoryObjectType" 'This selects the navigation pane - if already hidden, it will open it
DoCmd.RunCommand acCmdWindowHide 'This hides the navigation pane
Alternatively, you can also do the following VBA:
DoCmd.SelectObject acModule, , True 'This selects the navigation pane - if already hidden, it will open it
DoCmd.RunCommand acCmdWindowHide 'This hides the navigation pane
Please note, this will produce an error if you are using the Runtime version of Access (since the navigation pane is disabled). To work around this, you would have to check the SysCmd(acSysCmdRuntime); something like this:
If SysCmd(acSysCmdRuntime) = False Then
DoCmd.SelectObject acModule, , True
DoCmd.RunCommand acCmdWindowHide
End If