Hi
In my Access 2007 application I provide a number of buttons for users
to control what they see on the screen. My users go back and forth between
the initial 'switchboard' type of form (as a frontend interface) and the 
actual tables and queries that are listed in the navigation pane.  I have a 
button that shows/hides the nav. pane (with a simple SendKeys "{F11}" 
snippet) --  but I would like the groups to be collapsed when the pane 
becomes visible. Right now, when the button is clicked, the nav. pane is 
displayed, but will have various groups expanded depending on what the user 
had done before hiding the pane.
Is there a command to do this -- I can't seem to find one?
Also, is there a way to make the pane completely disappear--when you use 
SendKeys "{F11}" it only shrinks down to the vertical strip on the left side?
thanks much, KarenW

Private Sub cmdShowNavigationPane_Click()
DoCmd.SelectObject acTable, , True
End Sub

Private Sub cmdHideNavigationPane_Click()
DoCmd.NavigateTo "acNavigationCategoryObjectType"
DoCmd.RunCommand acCmdWindowHide
End Sub


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


"KarenW" <KarenW@discussions.microsoft.com> wrote in message 
news:369A484B-2E1F-4CE9-AD2C-39E6BB140611@microsoft.com...
> Hi
> In my Access 2007 application I provide a number of buttons for users
> to control what they see on the screen. My users go back and forth between
> the initial 'switchboard' type of form (as a frontend interface) and the
> actual tables and queries that are listed in the navigation pane.  I have 
> a
> button that shows/hides the nav. pane (with a simple SendKeys "{F11}"
> snippet) --  but I would like the groups to be collapsed when the pane
> becomes visible. Right now, when the button is clicked, the nav. pane is
> displayed, but will have various groups expanded depending on what the 
> user
> had done before hiding the pane.
> Is there a command to do this -- I can't seem to find one?
> Also, is there a way to make the pane completely disappear--when you use
> SendKeys "{F11}" it only shrinks down to the vertical strip on the left 
> side?
> thanks much, KarenW