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@hotmail.com> wrote:

>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?


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@4ax.com...

<martin@hotmail.com> wrote:

>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?


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