Printing a report in a navigation form

[DanKoz]

I have a navigation form that allows users to select from a multiple of different reports.

The only way I've found to be able to print the report is to use File/Print. No problem.

However, the print preview also shows all the navigation form buttons on the left, and a cut off report on the right. The report is cut off because the navigation buttons are taking up the necessary real estate.



How can I print just the report? and skip the navigation buttons.

Thanks,

Dan

[NoellaG]

Hi,

if you want to send the report immediatly to the printer:

docmd.OpenReport "ReportName",acViewReport

If you want to open the print preview first:

docmd.OpenReport "ReportName",acViewPreview

gr
NG

[DanKoz]

Thanks. I will give this a try.

Hopefully, this procedure will only print the desired report itself and not the side navigation bar, as well. Both the navigation bar and the cut off report show up in the print preview when I use the File/Print method.

Dan