Repeating Group Headers

[tskelton]

Hi, all. I would like to format my report so that if the detail section spills over to the next page, the word "continued" appears in the text box that's in the group header. In other words, on page 1, the group header says something like "California". Then the detail section follows, but it's too big to fit on page 1, so it spills over to page 2. At the top of page 2, I would like the Header to say "California (continued)". I know about the repeat section property, but that only repeats the header; it doesn't add "continued". Any ideas? Thanks for any and all suggestions!

-Todd

 

[kathryn]

Great question. I thought there must be a way, and I think I have found it. First thing you must do is to number the detail lines in your group. Look at the help topic "Count the number of records in each group in a report" in MS Access. Don't worry about adding the text box to the footer, just number the detail lines. Give the calculated textbox the name RecordNumber. Then in your group header, add a calculated textbox with ControlSource
=IIf([RecordCount]>1,"Continued","&quot

Let me know how it goes.

 

[tskelton]

Kathryn,

Your suggestion worked like a charm! I never even thought of using a record count. Thanks for your advice!

-Todd

 

[kathryn]

Glad to hear it worked. Especially since I am getting NOTHING productive done at work, due to a bad hard drive!

 

[RYankowitz]

Kathryn,

This is a great solution, but it only worked when I put the =IIf([RecordCount]>1,"Continued","&quot field in the Group Footer. Since the Header is formatted before the detail section, the RecordCount field has not yet been calculated. The Footer does know about it, as it is formatted after the Detail section.

Any thoughts?
[sig][/sig]

 

[tskelton]

Kathryn's solution worked for me. Do you have the Repeat Section property set to "Yes" for the header? I did.

Here's how I think it works: The header is simply repeating, not being calculated, when you want "Continued" to appear. A portion of the detail section has already been formatted, so the RecordCount field calculates as being >1 because the header is repeating, not being formatted for the first time.

Let me know if this helps at all.

-Todd [sig][/sig]