How do I set duplex on using printer object

[Doug Oliver]

We have various templates that we want to have printed in
duplex mode, regardless of what the user has set on their
printer settings. I found that if I include a reference
to the "Microsoft Access 10 Object Library" that I get a
printer object. One of the properties of that printer
object is Duplex. However, when I change the setting for
my default printer, and print the letter, it still comes
out with duplex off. If I change the printer setting
manually to duplex, then it prints correctly, so I know
the printer has a duplexer, and it works.

The duplex property will correctly report what the duplex
setting is for my printer, but when I change it, nothing
happens.

Can anyone please help me out in terms of what I am
missing?

 

[Jonathan West]

Hi Doug,

We have various templates that we want to have printed in
duplex mode, regardless of what the user has set on their
printer settings. I found that if I include a reference
to the "Microsoft Access 10 Object Library" that I get a
printer object. One of the properties of that printer
object is Duplex. However, when I change the setting for
my default printer, and print the letter, it still comes
out with duplex off. If I change the printer setting
manually to duplex, then it prints correctly, so I know
the printer has a duplexer, and it works.

The duplex property will correctly report what the duplex
setting is for my printer, but when I change it, nothing
happens.

Can anyone please help me out in terms of what I am
missing?

Yup, it is that Word doesn't have a Printer object, and changing it in
accrss doesn't affect that setting in Word. Take a look at this article for
a workaround.

Controlling the Printer from Word VBA
Part 2: Using VBA to control Duplex, Color Mode and Print Quality
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=116