I'm using Access 2003 and Windows 7. I have Acrobat installed as a printer.
I use the VBA code below to print a report to a pdf 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.ColorM
ode = acPRCMColor after selecting the printer but still get a black and white PDF only.
If I open my report manually, select the print menu, select 'Adobe PDF' as the printer and print, the resulting pdf is in colour.
I've tried the solution in http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21597698.html
but it doesn't solve my problem.
I get the problem on two different PCs so don't think the problem lies with any corrupt installations.
Can anyone help? Thanks.