PrintOut...print only the the current page of a report 1

[Saxie1]

From the print preview screen, I have my report set up to print OnClose. What syntax do I use to print only the record currently displayed, not the whole report?<br>
In MsWord I know I can use<br>
<br>
PrintOut Range:=wdPrintCurrentPage<br>
<br>
to do what I want, is there a similar command for MsAccess?<br>
Thanks<br>
Phil

 

[DougP]

There is but I don't think it works too well in '97<br>
you have to use code<br>
<br>
DoCmd.PrintOut acSelection, pagefrom, pageto, acDraft, Copies, collatecopies<br>
<br>
<br>
Create a command button and then paste this in the &quot;Build window&quot; or open properties and look for the On-click event it will be the only one with the word Event Procedure in it<br>
click the down arrow and paste it in there

 

[Saxie1]

Thanks DougP. Your right it doesn't work very well, I'll keep playing.<br>Saxie1