prtdevmode

[Chuck]

I am using Access 2000, and would like to control the printer used and some
page setup options (specifically the margins and paper used). I see some
references to PrtDevMode, but I can't see any reference on how to actually
use it. Could someone explain it to me or just post a solid reference link?

Thanks,
Chuck

 

[Allen Browne]

Hi Chuck.

PrtDevMode and PrtMip are somewhat cryptic - illustrated by the fact that
whoever wrote the PrtMip topic in the Access 2 help got it wrong so it
didn't work. The Access 95 person also got it wrong in a different place,
and the Access 97 one was also wrong in a different place. I quit checking
after that, but MSDN did have the correct coding example last time I checked
there.

For a detailed description, this chapter by Ken Getz et al covers it:
http://msdn.microsoft.com/archive/d...umControllingYourPrinterinMicrosoftAccess.asp

A major limitation is that you can only manipulate these properties in
design view, so they are no use if you create an MDE as most of us do.

An alternative for Access 97:
http://www.members.shaw.ca/AlbertKallal/msaccess/printch97.zip
For Access 2000 and later:
http://www.members.shaw.ca/AlbertKallal/msaccess/printch2k.zip

Access 2002 and 2003 include a Printer object you can manipulate much more
simply:
http://allenbrowne.com/AppPrintMgt.html

 

[Stanley L.]

Since PrtMip can only be set in design mode, if a user of an accde changes
the margins in the print dialog, will those changes be retained in the next
opening of the report. If YES, how can the original settings be locked in?
Thanks for your help to all repliers.