The following example returns the ForceNewPage property setting for the detail section of the Sales By Date report and assigns it to the intGetVal
variable.
Dim intGetVal As Integer
intGetVal = Reports![Sales By Year].Section(acDetail).ForceNewPage