View Full Version : DoCmd.PrintOut Event


TJBernard
04-18-2002, 08:05 AM
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
04-18-2002, 09:11 AM
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.