Predefine lines printing in a report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mashype - 06 Jun 2005 19:49 GMT

Can someone please tell be how to print a report that only prints
predefine number of records on each page

--
mashyp

Reply to this Message

Marshall Barton - 06 Jun 2005 22:39 GMT

>Can someone please tell be how to print a report that only prints a
>predefine number of records on each page.

Typical way to do this is to add a detail counter text box,
named txtDtlCntr to the detail section. Set it control
source expression to =1 And RunningSum to Over All.

Also add a line control named linNewPage at the very bottom
the the detal section.

Now you can use code in the detail section's Format event:
Me.linNewPage = (txtDtlCntr Mod predefinednumber) = 0

Signature

Marsh
MVP [MS Access]

Reply to this Message

mashype - 07 Jun 2005 14:55 GMT

Thanks it worked

--
mashyp

Reply to this Message