Predefine lines printing in a report

M

mashype

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

Marshall Barton

mashype said:
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
 
Top