Is there a way to only print the first page of a report

[lyndon.pace]

Hi All,

Basically when i hit a button, i want to be able to open a report, and only print the first page.

Is this possable?



Regards,

Lyndon

[lyndon.pace]

Theres a button command that lets you print current form. This will have to do for now.

[ansentry]

Reports are for printing not forms - Just my little piece of advice.

But this behind a command button.

Private Sub cmdPrint_Click()
DoCmd.OpenReport "Name of Report", acViewPreview
DoCmd.PrintOut acPages, 1, 1
DoCmd.Close acReport, "Name of Report"
End Sub

This is from VB help on PrintOut Method.

[lyndon.pace]

ansentry - You are a life saver, Thanks so much, this works like a charm.

Reports are for printing not forms - Just my little piece of advice.

But this behind a command button.

Private Sub cmdPrint_Click()
DoCmd.OpenReport "Name of Report", acViewPreview
DoCmd.PrintOut acPages, 1, 1
DoCmd.Close acReport, "Name of Report"
End Sub

This is from VB help on PrintOut Method.

[ansentry]

Lyndon,

Glad to help.