DoCmd.PrintOut Event

[TJBernard]

Is there anyway to print preview when the DoCmd.PrintOut action is performed?

I have a database that is using the docmd.printout method to give a screen shot of a form, and the users want to print preview this, if possible.

Thank you,

T.J.

 

[David R]

Rather than using DoCmd.PrintOut you could use:

DoCmd.OpenReport "ReportName" ,acViewPreview,,"[IDField] = " & Me.IDFieldControl

And design a report that looks just like your form. Forms in general aren't meant to be printed and your results can be less than optimal.