Saving Access Report to PDF in Color

PDFCreator PDFCreator English
1

Hey there, I'm a brand new PDFCreator user.  I have an Access report that I'm exporting to PDF.  My code produces a PDF just fine, it's just that it is in black and white.  My Access report is in color and I need the resulting PDF to be in color as well.  I found the following solution on the web but it hasn't proven successful:

Dim objAccess       As Access.Application

Dim objPDFCreator   As PDFCreator.clsPDFCreator

Set objAccess = New Access.Application

Set objPDFCreator = New PDFCreator.clsPDFCreator
With objPDFCreator
        If .cStart("/NoProcessingAtStartup") = False Then
            MsgBox "Can't initialize PDFCreator.", vbCritical + _
                    vbOKOnly, "PrtPDFCreator"
            Exit Sub
        End If
        .cOption("UseAutosave") = 1
        .cOption("UseAutosaveDirectory") = 1
        .cOption("AutosaveDirectory") = sPDFPath
        .cOption("AutosaveFilename") = sPDFName
        .cOption("AutosaveFormat") = 0    ' 0 = PDF
        .cClearCache
 End With

objAccess.DoCmd.OpenReport sReportName, acViewPreview

objAccess.Reports(0).Printer.ColorMode = acPRCMColor

I've excluded some code for the sake of brevity, my main point being the line in red.  When I run the above code, the PDFCreator system tray icon appears with a red dot and the process runs indefinitely and produces no PDF document.  It may be that the process takes an inordinately long time, but it runs so long that I assume something is wrong.  Replacing the last two lines with:

objAccess.DoCmd.OpenReport sReportName

results in a PDFCreator system tray icon with a green dot that finishes pretty quickly and produces a B/W PDF.

Any help would be appreciated

 

2

 

Problem: An Access “color” report when printed to .pdf using PDFCreator is converted to a Black & White .pdf. NOTE1: all PDFCreator settings are at the installed defaults. NOTE2: In my case, on 1 computer it prints in color just file, but not on another PC. One report prints in color but another one does not.This had been driving me crazy for the past 6 months until today. Hope this helps someone else.

This was tested on Windows XP SP3 and PDFCreaator v1.1.0 (Ghostscript 9.00) & v1.2.1 (Ghostscript 9.02). Printing was from a form with a command button and code similar to above.

Source of problem: Although the default PDFCreator printer settings in Printers and Faxes [Printing Preferences], [Paper/Quality] is set to Color and the report to print is set to use the default printer, the report page settings are actually set to Black & White for the PDFCreator printer.

This can be verified and fixed as below.

Solution: Select the report (don't open) and then select , from the Main Menu. Next select the tab. If the option is selected then the option is grayed out. So, select the option, then click , select the PDFCreator printer, and tab. Change the option to and then click until you are back to the Main Access screen.

That should do it.

NOTE: you can go back and now change the report page settings to use the default printer.

ieyes

 

3

Same problem from delphi, but with a special note:

If my actual default printer is PDFCreator, so it is the selected one from my app., then it prints colors ok, but if the app. has to change from another printer to PDFCreator (changing it at app. level, not as the new default printer for windows), then the printer is set to grey by it self.