Error printing a report (1 Viewer)

[Yuly17]

Hi,

I just create a new report and use the following code to print in pdf. The problem is the pdf file show me 11 pages when I just need 1. For the record the 11 pages are the same page information repeated 11 times. I have 250 records in the database

MyFileName = Me.AssemblyPartCode & "-GESNAcontrolsheet" & ".pdf"
DoCmd.OpenReport "GESNAcontrolsheet", acPreview, , strWhere
DoCmd.OutputTo acOutputReport, "GESNAcontrolsheet", acFormatPDF, MyPath & MyFileName, False
DoCmd.Close acReport, "GESNAcontrolsheet"

any suggestions? the program print other files at the same time without this issue.

 

[plog]

When you manually open the report inside access do you see the 11 pages? Or does this only occur when you export to pdf?

 

[Yuly17]

When you manually open the report inside access do you see the 11 pages? Or does this only occur when you export to pdf?

only see 1 page in the report preview

 

[Yuly17]

and if I change acPreview to acNormal, then it prints the 250 records on the same pdf file

 

[arnelgp]

only see 1 page in the report preview

how about on "Print Preview", do you see only 1 page and the navigation button is disabled?

 

[Yuly17]

Yes, but was quite long. I did change the margins and it works. Thanks