Print Previewing instead of printing a form 3

[philthepowerhouse]

Hey there,

I was wondering if there is a way to print preview a form before it prints so then it would be possible to see what is going to be printed!

I cannot find, using the wizard in access any wizard that will allow me to do this, is there another way??

Many thanks in advance!

Powerhouse

 

[PHV]

Have you tried this ?
DoCmd.RunCommand acCmdPrintPreview

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Remou]

Hi
Do you mean:
Docmd.OpenReport "ReportName", acViewPreview

 

[ZmrAbdulla]

DoCmd.RunCommand acCmdPrintPreview

________________________________________________________
Zameer Abdulla
Help to find Missing people
There’s a world of difference between editorials and advertorials

 

[philthepowerhouse]

Thank you all, works perfectly but do you know how I can remove any blank pages, the record will fit on the page but then page two is blank, page 3 contains a record and then a blank etc

Any ideas??

 

[ZmrAbdulla]

First of all forms are not for printing but for viewing entering data. Use reports instead. you have more control on that.
CanShrink/CanGrow also to be checked if you prefer form to print

________________________________________________________
Zameer Abdulla
Help to find Missing people
There’s a world of difference between editorials and advertorials