Half page report, cont on next page

  • Thread starter Thread starter Drew
  • Start date Start date
D

Drew

I have a database which is used for a Credit Card log... I now need to build
a report for this database. Problem is that the current form being used has
10 transactions listed on the first page, then the bottom of the page has
calculations and places for signatures. If there are more than 10
transactions, then a second page is used, listing the transactions for the
full page.

How can I show 10 records on the first page, then the rest of the records on
the second page?

Thanks,
Drew
 
Drew said:
I have a database which is used for a Credit Card log... I now need to build
a report for this database. Problem is that the current form being used has
10 transactions listed on the first page, then the bottom of the page has
calculations and places for signatures. If there are more than 10
transactions, then a second page is used, listing the transactions for the
full page.

How can I show 10 records on the first page, then the rest of the records on
the second page?
Click to expand...


Messy situation. If you can arrange to get your totals into
the Page Footer section, then here's a way to limit the
first page to 10 details.

Add an invisible(?) text box named txtLineCnt to the detail
section. Set its control source expression to =1 and set
its RunningSum property to OverAll. Also add a PageBreak
control named pgEject at the bottom of the detail section.

Now you can use code to start a new page after the 10th
details and make the page footer section invisible after the
first page by using this code in the detail section's Format
event procedure:
Me.pgEject.Visible = (Me.txtLineCnt = 10)
Me.Section(4).Visible = (Me.txtLineCnt <= 10)
 
Back
Top