Private Sub Create_PDFReport(sPath As String, strRepName As String, strBaseName As String, sWhereCond As String, sPDFFileName As String) [indent]Dim sPDFPrinter As String Dim sPDFFile As String Dim PdfErrorMessage Dim buff1 As String, buff2 As String Dim sizeofbuff As Long Dim rpt As Access.Report Dim prtr As Access.Printer On Error GoTo Err_PDF sPDFPrinter = "Corel PDF Creator" sPDFFileName = strBaseName & ".pdf" sPDFFile = sPath & sPDFFileName ' sPDFFile = "D:\Users\Owner\Documents\PDF Files\Corporate Contract.pdf" ' determine size of buffer needed If GetDefaultPrinter(vbNullChar, sizeofbuff) = 0 Then buff1 = Space$(sizeofbuff) ' get default printer (physical printer) If GetDefaultPrinter(buff1, sizeofbuff) = 1 Then ' assign new default printer (Corel PDF Creator - outputs to D:\Users\Owner\Documents\PDF Files) buff2 = sPDFPrinter & vbNullChar If SetDefaultPrinter(buff2) = 1 Then 'successful 'MsgBox "default printer changed to: " & buff2 If ChkFileAttr(sPDFFile) <> -1 Then Kill sPDFFile End If If ChkFileAttr(sPDFFile) <> -1 Then PdfErrorMessage = "Unable to delete " & sPDFFile & " " & ChkFileAttr(sPDFFile) GoTo Err_PDF End If DoCmd.OpenReport strRepName, acViewPreview, , sWhereCond Set rpt = Reports(strRepName) Set prtr = rpt.Printer prtr.ColorMode = acPRCMColor DoCmd.PrintOut acPrintAll, , , acHigh, 1 ' give it a chance to happen! Delay (2) [b]DoCmd.Close acReport, strRepName, acCloseSave[/b][highlight #EDD400][/highlight] Delay (2) If SetDefaultPrinter(buff1) = 1 Then 'MsgBox "Default printer restored to: " & buff1 Else MsgBox "Unable to restore default printer: " & buff1 End If End If End If End If Delay (1) Exit Sub Err_PDF: MsgBox "PDF Error: " & PdfErrorMessage End Sub