Printing Reports & Queries from Navigation form

[davejohno]

I have created a navigation form in access 2010 and all reports and queries show correctly. However when trying to print any report\query open on the navigation form the right hand edge of the report\query is not shown on the print preview, this is probably due to the large blank area on the left hand side where the buttons are (although they are not shown in preview mode).
Is it not possible to print a report correctly using the navigation form ?
Is the only way to print a report\query by opening it individually?

 

[HiTechCoach]

Is the only way to print a report\query by opening it individually?

I have yet to find any other way.


Here is what I do:

With the report in design mode, Insert a button on the report.

Add the following VBA code to the "On Click" event of the button:

DoCmd.OpenReport Me.Name

Set the button property for "Display When" to "Screen Only". This will make the button so it does not print on the report when sent to a printer.

Now you can click the button to print the report