Discussion Locked

Windows Default Printer-VBA (MS Access)

0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I can list all of the installed printers on any given pc. I want to be able to tell which one is the current default - programmatically.

I have lots of users with different kinds of local printers. They need to be able to put a specific form intheir local printer, & have the Access report line up exactly to with in 1/64 of an inch max. No matter which printer they use - The report will always print to their default windows printer. I figure that I can set the top & left properties of each of the fields programmatically depending on which printer they are using. The spacing between objects is consistent.

HELP!

6 replies

by francodacosta

The Printer Object refers to the default printer.

If you want to know what printer is the deafult use the .DeviceName or .DriverName properties of the printer object.

Tho choose another printer try using the common Dialog Control with the .PrinterDefault = True.

by sheryl v

Am I missing a a reference? Or is it VBA that's the problem, the printer object doesn't auto-capitalize and the properties aren't recognized either. F1 gets "key word not found", and searching the Object browser doesn't find it either.

This discussion is closed to new replies.