print scaling
 

hi,

i have the following:

ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True

is there a way i can amend this so that i can instruct to print at 80
percent of original size?

thanks in advance,
geebee

print scaling
 

Try:

ActiveWindow.SelectedSheets.PageSetup.Zoom = 80
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True

I didn't test this so you might have to loop through the sheets to set the
zoom.


"geebee" wrote:

hi,

i have the following:

ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True

is there a way i can amend this so that i can instruct to print at 80
percent of original size?

thanks in advance,
geebee

print scaling
 

hi,

would this pretty much be the same syntax for Access VBA?

ActiveWindow.SelectedSheets.PageSetup.Zoom = 80
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True

how could i amend this to print an Access form?

thanks in advance,
geebee


"JLGWhiz" wrote:

Try:

ActiveWindow.SelectedSheets.PageSetup.Zoom = 80
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True

I didn't test this so you might have to loop through the sheets to set the
zoom.


"geebee" wrote:

hi,

i have the following:

ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True

is there a way i can amend this so that i can instruct to print at 80
percent of original size?

thanks in advance,
geebee

print scaling
 

I don't have Access, but one way to find out is to try it.

"geebee" wrote:

hi,

would this pretty much be the same syntax for Access VBA?

ActiveWindow.SelectedSheets.PageSetup.Zoom = 80
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True

how could i amend this to print an Access form?

thanks in advance,
geebee


"JLGWhiz" wrote:

Try:

ActiveWindow.SelectedSheets.PageSetup.Zoom = 80
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True

I didn't test this so you might have to loop through the sheets to set the
zoom.


"geebee" wrote:

hi,

i have the following:

ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True

is there a way i can amend this so that i can instruct to print at 80
percent of original size?

thanks in advance,
geebee