When working on a database in Access 2007 it may be useful to hide the Navigation Pane (Shutter bar) at the left hand side of the screen.
We can do this manually by changing the Navigation options in the Current Database properties within the Access options window. (Click the Microsoft Office Button and then click the Access Options button).
You may then disable the the Navigation Pane (for this database) by using the Enable Navigation Pane checkbox.
You can also hide and unhide the Navigation Pane at anytime by pressing the F11 key. (You could use the SendKeys code from my other post here and replace F1 with F11 to do this in VBA code).
However, it may be useful to remove the Navigation Pane entirely.
We can do this by using the following macro:
1) Start a new macro.
2) In the “Action” column select “SendCommand”
3) In the “Arguments” column select “WindowHide”
Running this macro when your database first loads will now hide the navigation pane.