Print report in Balck and White

[KPatel]

Hi

I am trying to write a code to print a report and form in
black and white. I did find the following in the help
menu:

Sub SetPrinter(strFormname As String)

DoCmd.OpenForm FormName:=strFormname, view:=acDesign,
datamode:=acFormEdit, windowmode:=acHidden

With Forms(form1).Printer
.ColorMode = acPRCMColor
End With

DoCmd.Close objecttype:=acForm,
objectname:=strFormname, Save:=acSaveYes

I know I can change acPRCMColor to acPRCMMonochrome, but
the problem with the code above is that I have a secured
database and no one has design permissions. Is there
another way to accomplish this wihtout allowing anyone
design rights.

Any help would be appreciated.

Thanks in advance

 

[Larry Linson]

The Access 2002 Help on Printer.ColorMode indicates the property is
Read/Write. I see nothing to indicate it is writable only in Design View.
Try setting it at runtime.

Larry Linson
Microsoft Access MVP