Page Breaks in Reports

[Guest]

I would like to make a page break that allows four records to appear per page
without breaking in the middle of the record data.

Is this possible, if yes... How?

Thanks

 

[Guest]

Hi Gina

Press F1 one and search on - Add a page break to a report


It will give you the method to force a page break after a certain number of
record.

Hope this helps

 

[fredg]

I would like to make a page break that allows four records to appear per page
without breaking in the middle of the record data.

Is this possible, if yes... How?

Thanks

Add an unbound text control to the report detail section.
Set it's Control Source to:
=1
Set it's Running Sum property to Over All.
Name this control "txtCounter"
You can make it not visible if you wish.

Add a PageBreak control to the bottom of the report detail section.

Code the Detail Format event:
Me!PageBreakName.Visible = (txtCounter Mod 4 = 0)

 

[Guest]

This worked perfectly. Thank you so much.

 

[Guest]

I tried this step but I am having problems with this. I cannot find the
"Detail Format Event" I was able to add the txtcounter, but I am having
problems with the page break. I only want one record per page. Any help?

Jenna

 

[Guest]

I am trying do something similar and tried these steps but I cannot get it to
work properly. I am trying to put one record per page. I was able to put
the text counter in, but I can not find the place where to put the code for
the "Detail Format Event." I only have four options for the page break. Any
advice?