Repeat Section Question

[TJBernard]

I have a report with just one header and detail section below, which makes for a simple report. I have set the Repeat Section property = Yes on the header, so that the header repeats at the top of each page.

My only problem is in some cases the Header will print at the bottom of the previous page, then run out of room for Detail information, and the on the next page print the Header again with the Detail information, like this:

Missouri Users

--------------------------------New-Page---------------------------------

Missouri Users

Travis Watson
8831 west 1st
Kansas City, Missouri


I would like the header at the bottom of the previous page removed if this is possible. I am not sure if there is a way to code this or not, but I felt my best chance of finding a solution would be on this message board.

Thank you for your time,

T.J.

 

[Rich]

Did the solution offered to you on your last post on the subject not work?

 

[TJBernard]

That solution was a great idea, but when I tried that I get something like this.....


Iowa Users

Brad Stevens
1804 E 1st Street
Des Moines Iowa





(Too much blank page)






----------------------------New-Page------------------------------

Missouri Users

Kyle Gundy
1103 W. 3rd
Kansas City, Missouri


---------------------

There was too much white space after the header section detail information and the bottom of the page before the new page was forced.

Thank you though for the advice.

T.J.

 

[TJBernard]

Here is a link to the original post. Sorry about posting this twice.

Thank you,

T.J.

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=60007

 

[TJBernard]

Darn did not work, let me try again here....

My first post for this question

There this should work, ignore the above message.

 

[Rich]

Which Header are you repeating?

 

[TJBernard]

The State Header is now being repeated.

It looks like this currently on the report:

Iowa Users

James K. Dold
8845 E. 55th
Des Moines, Iowa

Brett Wilderman
8907 5th Ave.
Ames, Iowa

Brian Zook
9350 Walker Av.
Marshalltown, Iowa

Missouri Users

-----------------------------New-Page----------------------------------

Missouri Users

Brad Davis
103 12th Street
Cameron, Missouri



I would like the "Missouri Users" the state header on the first of these two pages removed.

Thank you to everyone for their time and effort, it is greatly appreciated.