MS Access 2010 problem with DoCmd.OutputTo acOutputReport, strReportName, acFormatPDF
Posted on 2014-03-14
I have an Access report that contains some formatting in the Report_Open section of code. This turns on or off a label based on a computation.
When I run DoCmd.OutputTo acOutputReport, strReportName, acFormatPDF to save the report as a PDF the required code does not run because the report is not opened. Is there a way to set the label info before the OutputTo command is run? I can't have the user save the previewed report as a pdf because I am merging a number of pdf files together using Stephen Lebans code. All of my reports are working with no problems except this one.