Print report in Balck and White

  • Thread starter Thread starter KPatel
  • Start date Start date
K

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
 
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
 
Back
Top