invoice print

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

klp - 24 Jan 2007 19:57 GMT

Is there a way to tell an invoice to print so many lines then break? I could
put a page break in but we have text that prints after the lines of the
invoice print and I don't want them to be broken by putting a few lines on
the 1st page of the invoice and the rest on the second page. This is in the
LineNo footer of the invoice where I need to tell where to break the page.
Any suggestions.

Reply to this Message

Duane Hookom - 25 Jan 2007 04:41 GMT

You can force page breaks after a designated number of records. For instance
if you wanted to place 10 records per page:
-Add a text box to the detail section:
Name: txtCountDetails
Control Source: =1
Running Sum: Over All
Visible: No
-Add a page break at the bottom of the detail section
Name: PgBrk
-Add code to the On Format event of the Detail Section:
Me.PgBrk.Visible = Me.txtCountDetails Mod 10 = 0

Signature

Duane Hookom
Microsoft Access MVP

> Is there a way to tell an invoice to print so many lines then break? I could
> put a page break in but we have text that prints after the lines of the
> invoice print and I don't want them to be broken by putting a few lines on
> the 1st page of the invoice and the rest on the second page. This is in the
> LineNo footer of the invoice where I need to tell where to break the page.
> Any suggestions.

Reply to this Message