Prev: Limit and group slices in a Pie Chart
Next: Error 2709
From: IThoughtIKnewAccess on 11 Sep 2009 15:59
Please let me know if there is a way that I can add " - continued" if a group
header repeats (I have set the Repeat Section to yes").

Thanks
From: Marshall Barton on 11 Sep 2009 17:12
IThoughtIKnewAccess wrote:

>Please let me know if there is a way that I can add " - continued" if a group
>header repeats (I have set the Repeat Section to yes").


Of you can quarantee (via KeepTogether) that the first
detail in each groupwill not spill over onto a second page,
then add a text box (named txtDtlCnt) to the detail section.
Set its control source expression to =1 and RunningSum to
Over Group.

Then you can use a text box in the group header with an
expression like:
=IIf(txtDtlCnt > 1, "Continued","")

--
Marsh
MVP [MS Access]
 | 
Pages: 1
Prev: Limit and group slices in a Pie Chart
Next: Error 2709