Report to a printer or preview mode?

[Gkirkup]

I have a report which usually prints to a printer, but sometimes we want it to be in preview mode so that we can make a PDF and email it. I don't want to duplicate the report. Is there a way that I can programably select printer or preview mode? The report is actually a packing list used many times a day, so always having it in preview mode and manually selecting a printer is not an option.

Robert

 

[June7]

I do this.

DoCmd.OpenReport "reportname", IIf(MsgBox("Preview report?", vbYesNo) = vbYes, acViewPreview, acViewNormal)

This gives user the option. Can use other criteria if prefer.

 

[isladogs]

Variation on a theme. I use a checkbox:

 If Me.ChkPreview = True Then
        DoCmd.OpenReport ReportName, acViewPreview
Else
        DoCmd.OpenReport ReportName, acViewNormal
End If

In your case, set the checkbox default = False so the report normally prints without preview

 

[theDBguy]

Hi. Lost of options for you. You can also have separate buttons to "print," "preview," "email," or "export to PDF."

 

[deletedT]

I have a Print - view option box in my forms