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
If .cStart("/NoProcessingAtStartup") = False Then
MsgBox "Can't initialize PDFCreator.", vbCritical + _
.cOption("UseAutosave") = 1
.cOption("UseAutosaveDirectory") = 1
.cOption("AutosaveDirectory") = sPDFPath
.cOption("AutosaveFilename") = sPDFName
.cOption("AutosaveFormat") = 0 ' 0 = PDF
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:
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
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.
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.