Left hand pane gets auto-hidden or remains expanded on Form opening

SachAccess

Active member
Local time
Tomorrow, 00:32
Joined
Nov 22, 2021
Messages
410
Hi,
I have few forms in MS Access DB. On opening few of the forms, left hand pane gets auto-minimized.
When form is close then navigation pane comes back to original expanded state.
Is it due to form size, I may be wrong, but mostly this is happening for wider forms.
Small size forms usually do not minimize left hand pane. Please correct me if am wrong.
How do I keep this uniform, I want to minimize navigation pane for any form opening.
Is it possible. Can anyone please help me in this.
 
Add this code to a standard module:

Code:
Public Function MinimizeNavigationPane()

    DoCmd.NavigateTo "acNavigationCategoryObjectType"
    DoCmd.Minimize
        
End Function

Then add the line MinimizeNavigationPane to the Load event of each form
 
Hi @isladogs thanks for the help. I am trying this. Have a nice day ahead. :)
 
If you close the nav pain(sic) before you prepare the db for distribution, it will stay closed if you check the box that says to not open it. Although, certain types of code cause it to pop back open. I thought that was fixed but if it isn't in your version, then add the code to any form that imports/exports a file.
 

Users who are viewing this thread

Back
Top Bottom