Of a report's group footer I would like to set the 'New page' property while
loading the report, depending on the user's choice. The values can be "None"
or "After section".

Is it possible to accomplish this? Perhaps an example?

Thanks, Martin

<martin (AT) hotmail (DOT) com> wrote:


How do users specify their choice? If it's in a form check
box, you could use:

If Forms!theform.thecheckbox Then
Me.Section(6).ForceNewPage = 2
End If

--
Marsh

Excellent Marshall! It took me some time to find the right constance and
then I discovered that you already wrote the right number
For completion here are the constants:

Setting Constant Description
0 acDetail Form detail section or report detail section
1 acHeader Form or report header section
2 acFooter Form or report footer section
3 acPageHeader Form or report page header section
4 acPageFooter Form or report page footer section
5 acGroupLevel1Header Group-level 1 header section (reports only)
6 acGroupLevel1Footer Group-level 1 footer section (reports only)
7 acGroupLevel2Header Group-level 2 header section (reports only)
8 acGroupLevel2Footer Group-level 2 footer section (reports only)

Thanks,
Martin


"Marshall Barton" schreef in bericht
news:k9e1p6t77k1hrlt6kmk6hj0dckbrtdqeqj (AT) 4ax (DOT) com...

<martin (AT) hotmail (DOT) com> wrote:


How do users specify their choice? If it's in a form check
box, you could use:

If Forms!theform.thecheckbox Then
Me.Section(6).ForceNewPage = 2
End If

--
Marsh