It seems that, when generating PDF with DoCmd.Output to command, PDF file gets unusually big. This is what I am using now:
DoCmd.OpenReport "Report", acPreview, , "[ID]= forms![frmGenerate]![ID]", acHidden
DoCmd.OutputTo acOutputReport, "report", acFormatPDF, filePath, True
Current PDF file is around 1MB. If the same file gets generated manualy, with "print to pdf" directly from report page, file size us around 200kb. I have read that DoCmd.OutputTo acOutputReport generates file with everything embedded, fonts gets multiplied, etc. Is there any way to get the PDF file smaller. I couldn't find anything related to PDF (similar question has been asked here.
Cheers.
DoCmd.OpenReport "Report", acPreview, , "[ID]= forms![frmGenerate]![ID]", acHidden
DoCmd.OutputTo acOutputReport, "report", acFormatPDF, filePath, True
Current PDF file is around 1MB. If the same file gets generated manualy, with "print to pdf" directly from report page, file size us around 200kb. I have read that DoCmd.OutputTo acOutputReport generates file with everything embedded, fonts gets multiplied, etc. Is there any way to get the PDF file smaller. I couldn't find anything related to PDF (similar question has been asked here.
Cheers.