![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
I want to set the margins on a report to specific settings so I'm thinking this will set the prt object to my default printer * * Dim prt As Printer * * Set prt = Application.Printers(0) but it doesn't and application.printers.count correct shows that I have eight possible printers so I could cycle through them if there was a prt property for 'default printer' *but I can't find one is there a way to do this ? |
#3
| |||
| |||
|
|
On Nov 9, 5:19*pm, Roger <lesperan... (AT) natpro (DOT) com> wrote: I want to set the margins on a report to specific settings so I'm thinking this will set the prt object to my default printer * * Dim prt As Printer * * Set prt = Application.Printers(0) but it doesn't and application.printers.count correct shows that I have eight possible printers so I could cycle through them if there was a prt property for 'default printer' *but I can't find one is there a way to do this ? looks like this will do it * *application.Printer.DeviceName and application.printer also has a rightMargin setting so ?application.printer.RightMargin *360 how does 360 relate to a 1" margin if I change the margin using * * application.Printer.RightMargin = 200 will it apply to any reports that are printed or export to pdf (access2010) |
#4
| |||
| |||
|
|
On Nov 9, 5:19*pm, Roger <lesperan... (AT) natpro (DOT) com> wrote: I want to set the margins on a report to specific settings so I'm thinking this will set the prt object to my default printer * * Dim prt As Printer * * Set prt = Application.Printers(0) but it doesn't and application.printers.count correct shows that I have eight possible printers so I could cycle through them if there was a prt property for 'default printer' *but I can't find one is there a way to do this ? looks like this will do it * *application.Printer.DeviceName and application.printer also has a rightMargin setting so ?application.printer.RightMargin *360 how does 360 relate to a 1" margin if I change the margin using * * application.Printer.RightMargin = 200 will it apply to any reports that are printed or export to pdf (access2010) |
![]() |
| Thread Tools | |
| Display Modes | |
| |