Access 2007 OutputTo PDF Different from Printed Output -
using access 2007 sp3, have report. when printed printer, , in print preview, report looks fine. within margins, proper output, no pages...everything fine.
when outputting same report pdf, report appears zoomed, , content clipped. no pages printed if i've gone beyond margins. here code i'm using:
docmd.openreport rptname, acviewpreview docmd.outputto acoutputreport, "", acformatpdf, pdffilename, false docmd.close acreport, rptname
the report opened in preview mode first page events fire show/hide objects based on fields in recordset feeds report.
i've tried both screen quality , print quality parameters in outputto call, same results. also, if call outputto on 1 line , events don't fire, report still zoomed/clipped, has objects not hidden.
i've tried on 2 different machines, 1 running windows 7 , 1 running windows server 2008.
even when setting break point on outputto line, preview looks fine...it's resulting pdf file doesn't right.
the things can think of are:
try saving report directly, without opening first, replace 3 lines of docmd
single one:
docmd.outputto acoutputreport, rptname, acformatpdf, pdffilename, false
also make sure report fit page , properties allows rescaled.
instance, here settings use report save pdf directly same docmd.outputto
above.
Comments
Post a Comment