Page breaks in reports

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

Hi,
I have a report which I want for the detail section to be printed only
up to a certain number of times and then to force a new page. So it would
print 30 records then force a new page. Can this be done in vba and if so
where? Or is there an easier way of doing it?

Thanks in advance
Paul Mitchell
 
Paul,
Add a page break control to the detail section.

Then add an unbound control to the detail section.
Set it's control source to
=1
Set the Running sum property to Over All
Name it RecCount.
If you wisn you can make it not visible.

Code the Detail Format event:
LineBreakName.Visible = RecCount Mod 30 = 0
 
There is a step by step description of your very example
in the help file. Click Help and index. Type "page break"
and follow the instructions on using a macro to set your
page break.
 
Back
Top