Print Preview Form

[luceze]

I'm having problems opening a form in the print preview screen from a command button. I can send it straight to the printer with docmd.printout but I would like the user to be able to see the preview first.

Thanks,
Eric

 

[donnadee]

Can you cut and paste the form design into a report and add a print preview command button from the form side?

 

[luceze]

Didn't work and as far as I can tell this can't be done through conventional means. Thanks anyway.

 

[ryanku]

1. Create a command button, name that button 'cmdCurrentFormPreview'
2. Set 'Display When' property to 'Screen Only'
3. Inside cmdCurrentFormPreview's 'On Click' event, put this line:
DoCmd.OpenForm Me.Form.Name, acPreview
4. To print preview this current form, just click this cmdCurrentFormPreview button

 

[luceze]

Thanks for the reply. I had already tried that but it clears out all the user entered fields when it reopens the form.