Exporting an Access report to PDF format

[Glenn_Suggs]

Hello... Does anyone know the syntax for exporting an Access report to PDF format using VBA code. I'm thinking it may be similar to using TransferSpreadsheet to get a table or query into Excel but I've never seen it done before.
Thanks in advance,
Glenn

[pbaldy]

Look at

DoCmd.OutputTo

[Glenn_Suggs]

What should I use as the acFormat parameter?

[Minty]

The avilable outputs are ;

OutputFormat

Required

The output format acFormatHTML acFormatPDF acFormatRTF acFormatSNP acFormatTXT acFormatXLS acFormatXLSB acFormatXLSX acFormatPS

From here http://access-excel.tips/access-vba-...tputto-method/