Problem Printing Reports from a Tabbed Navigation Menu (Access 2013)

[dhans]

Help. I want to print a report from a tabbed navigation menu and when I do, it prints the entire screen including the navigation menu. I only want the report to print. I tried to put in a docmd.printout event in a command button on the Report, but it still prints out the entire screen and not just the report. :banghead:

I've exhausted my limited knowledge base on what to try next. Any ideas on where to look for a solution will be welcome.

 

[pr2-eugin]

Maybe something like a Printer Selection Utility be helpful?

 

[dhans]

I don't have a problem getting it to a printer, my problem is in the format of what is being sent to the printer. The print command is sending what is sending, essentially, a screenshot that includes the tabbed navigation menu, and not the report exclusively which is what I want.
I don't see how a Printer Selection Utility will solve that problem, unless I'm missing something in my reading of it.

 

[pr2-eugin]

I don't have a problem getting it to a printer, my problem is in the format of what is being sent to the printer. The print command is sending what is sending, essentially, a screenshot that includes the tabbed navigation menu, and not the report exclusively which is what I want.
I don't see how a Printer Selection Utility will solve that problem, unless I'm missing something in my reading of it.

Because the PrintOut method will print the active object in the open database. In your case, the Navigation Form. The method by Allen Browne will choose which report you wish to print, then send that to the Printer. Not the active object.

 

[dhans]

Ah, I see that now. Could the same be accomplished (aside from being able to adapt default printer) with adding a DoCmd.OpenReport line previous to DoCmd.PrintOut?