Print Preview Button

[tbeegz]

How do I put a print preview button on a form?

 

[Fizzio]

What do you want to preview? a form printout or a report?

 

[tbeegz]

I want to preview the form printout.

 

[David R]

Forms aren't designed to be printed. Design a report that mimics the shape of your form, and pass the specific ID of the record you want to the report from a button on your form.

Something like

DoCmd.OpenReport "FormReport", acViewPreview, , "[ID_Field] = " & Me.[ID_Field_Control]

on a button on your form will open the report in preview mode. Note that this presumes your id field is numeric. If it's text, add single quotes like so:

"[ID_Field] = '" & Me.[ID_Field_Control] & "'"

HTH,
David R


[This message has been edited by David R (edited 04-02-2002).]

 

[tbeegz]

Thanks for the tips. I generated reports similar to my forms and made buttons on the forms to print them out. Actually, they look better than the printed forms anyway. Thanks again.