Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Limit number of pages in 'Print Preview' 1

Status
Not open for further replies.

kramerica

Technical User
Jun 19, 2001
74
US
Is there a way to display just the first page of a report?
Let's say there is a report that you would like to print preview, and it is 170 pages. Can you do a preview of just the first page!?

I know you can PRINT the first page only with VB code.. Is it possible to PREVIEW the first page ONLY.

How would you preview just the last page?
 
You can limit the amount of data shown using a select statement i.e. me.recordsource = "Select * From YrTbl Where date=" & date()
Does this help you, I do not think that this was the reply that you wanted but it might be your solution.

Herman
 
check out DoCmd.printout in the help file
The second/third paramters are Page From ,Page to
It works for prints but it might go for a preview


Mike
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top