Adobe PDF Won't Print in Colour

[Netherby]

Hi,

I'm using Access 2003 and have Acrobat installed as a printer.

I use the following code to print a report but the resulting pdf file is always in black and white even though I use colour fonts in my report. I've set all my Acrobat options to colour manually wherever I can.

Set Application.printer = "Adobe PDF"
Crit$ = "[Invoice_no]= " & Val(frmS![ListBoxInvoice])
DoCmd.OpenReport "rpt_invoice", acNormal, , Crit$

I tried adding Application.printer.ColorMode = acPRCMColor after selecting the printer but still get balck and white only.

If I open the report manually, select the print menu, select 'Adobe PDF' as the printer and print, the resulting pdf is in color.

Can anyone help? Thanks. David.

 

[lameid]

What happens if you set the PDF printer correctly and save the report (save the printer with the report) and then print?

I am just wondering if it is something peculiar about the driver default or something inherrent about the application printer... Maybe there is a property you can set for color on that object?

There is an old GNU probject I used to use with Access 2003... PDF Creator. The original GNU project is free... The advantage to it is it can be set to save to a file name (that you can rename, move etc.)

Another alternative PDF printer is CutePdf.

Both print in color and both are free. If nothing else, trying a different printer may be diagnostic.

 

[Netherby]

lameid,

Fantastic, you've solved it.

I save the printer with the report as you suggested and I now get everything in perfect color.

Many thanks.

 

[lameid]

I am glad you found a workaroundthat works for you.

Although, all we did is confirm it has something to do with the application printer behavior.

I point this out for anyone looking at this thread later.