Hi All, I currently create a PDF of our weekly report via the following code. This works fine except when a font is not recognised and the PDF document has replaced the missing data with a "?". On the other hand if I run the report maually and save using save PDF or XPS than the final PDF version is fine. The attached doc has the PDF document properties for both and the only thing that really stands out is that the Manual process is using “Acrobat Distiller 11.0” instead of Access. Any ideas how I can trigger the automated process to use Distiller instead of the acFormatPDF.



DoCmd.OutputTo acOutputReport, "WEEKLY REPORT - Working Draft", acFormatPDF, FilePath
PDF font issue.zip


Cheers Mick