Access report and pre-printed form

  • Thread starter Thread starter SF
  • Start date Start date
S

SF

Hi,

I have my access report invoice printed on a per-printed invoice header (5"
x 8"). The report works fine except that if the report has more than 20
lines, it break to new page. Is there a way to put at the botton 'Continued
to next page...'?

SF
 
SF said:
I have my access report invoice printed on a per-printed invoice header (5"
x 8"). The report works fine except that if the report has more than 20
lines, it break to new page. Is there a way to put at the botton 'Continued
to next page...'?
Click to expand...


Add a text box named txtInvLines to the invoice group's
header section. Set its control source expression to
=Count(*)

Add a text box named txtLineCount to the detail section.
Set its control source expression to =1 and Running Sum
property to Over Group.

Add a text box to the page footer section and set its
control source expression to:

=IIf(txtLineCount < txtInvLines,"Continued on next page","")
 
Marsh,

Thank you for your prompt response.

SF
Marshall Barton said:
Add a text box named txtInvLines to the invoice group's
header section. Set its control source expression to
=Count(*)

Add a text box named txtLineCount to the detail section.
Set its control source expression to =1 and Running Sum
property to Over Group.

Add a text box to the page footer section and set its
control source expression to:

=IIf(txtLineCount < txtInvLines,"Continued on next page","")
Click to expand...
 
Back
Top