Re: print form

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



Hi,
Try this code:
DoCmd.PrintOut

this will print active form

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com


"geebee" <geraldjr30@xxxxxxxxxxx(noSPAMs)> wrote in message news:BA249610-BA24-4672-AE43-FC571D21E0FD@xxxxxxxxxxxxxxxx
hi,

i have the following print code which works in excel, but i am trying to
figure out how to modify it to work in access to print a form:

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

thanks in advance,
geebee

.


Quantcast