Printing (one page) Form

[alex]

Hello Experts,

I've placed a command button on a form that initiates the following
command (prints the form):

Private Sub Command51_Click()
On Error GoTo Err_Command51_Click

DoCmd.PrintOut

Exit_Command51_Click:
Exit Sub

Err_Command51_Click:
MsgBox Err.Description
Resume Exit_Command51_Click

End Sub

Can someone tell me how to tweak this statement so that the command
only prints the FIRST PAGE?

Thank you,
alex

 

[Douglas J. Steele]

Forms aren't really intended for printing: that's what reports are for.

There's a built-in capability to convert your form to a report by
right-click on the form in the database window and select the Save as Report
option.

 

[alex]

Forms aren't really intended for printing: that's what reports are for.

There's a built-in capability to convert your form to a report by
right-click on the form in the database window and select the Save as Report
option.

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no private e-mails, please)












- Show quoted text -

Thanks for the response Doug.

For this application, priting the form would work better than printing
a report.

I need the form to act as sort of a report card to attach to a file; I
tried the report option and it was too cumbersome.

Can you modify the VBA code to only print one page upon click?

alex