Access - Printing Reports In Colour

[Marky]

Hey all,

I have a print button in a form that is programmed to print a report - but it prints in black and white.

I need the report printed in colour.

Here is the code:

Private Sub print_current_date_data_Click()
On Error GoTo Err_print_current_date_data_Click

    Dim stDocName As String

    stDocName = "ctu_list_current_month"
    DoCmd.OpenReport stDocName, acNormal

Exit_print_current_date_data_Click:
    Exit Sub

Anyone know what the code is to have it colour?

Thanks,
Marky

 

[feriso]

Just off the top of my head, but surely that is to do with the default printer settings. Have you tried printing something from another office prog and does that come out in colour with out changing the settings?

 

[Marky]

Just off the top of my head, but surely that is to do with the default printer settings. Have you tried printing something from another office prog and does that come out in colour with out changing the settings?

Yeah it looks like it defaults to black - We have two printers (One physical printer but two printer on the computer black and coloured)

But I don't want to change the default if I don't have to - I just need this report to be in colour.