Help needed when printing - Printing always opens the Navigation Pane, How do I stop this?

[HybridOzone]

Hello....



I have built a database to look after our company Customer Details and Quality Complaints.
The database is split into Front/Back end and the FE application is distributed between users.
It is limited on the FE application so it only allows a startup form which then drives all other forms, queries & reports.
The Navigation Pane is hidden as default in File/Options/Current Database.
Many of the forms/reports are printable and have a button that has been autogenerated (add button) during the design phase.
As soon as anything is printed the Navigation Pane opens and becomes accessible for all.

I have looked at many forums and cannot find anything that remotely associates with this problem.
I also cannot find any VBA that will stop this happening only VBA to hide the Pane.

Please see pictures below:

1. Before clicking "Print" on form

2. After clicking "Print" on form


I will appreciate any/all solutions, ideas or assistance with this issue as the last thing I want is to give basic users access to the various forms, queries and reports in the FE application.

Thanks

[Minty]

What is the code behind the print button ?

[HybridOzone]

As this is a macro from the built in Macro builder>



I know I should really be using VBA. I am relatively new and self taught in Access and only just started using VBA.
If there is a VBA alternative then I would be very happy to know about it c",

[June7]

Well, I can't fix the macro but VBA does not open the pane.

DoCmd.PrintOut acPrintAll

[HybridOzone]

Perfect June7!!!
So simple and yet so effective.....I really need to do a VBA course as this simple line has totally removed my issue.

Thanks for your support this is solved