get number of pages for ActiveReport??

[geetar_king]

I am running some code which has a conditional statement that makes the code act differently depending on whether the report is a single (1) page or not.

Is there a way to get the number of pages in a report?

I have tried Screen.ActiveReport.Pages.Count but it doesn't work

 

[josephff]

http://www.access-programmers.co.uk/forums/showthread.php?t=196521

try this

 

[vbaInet]

1. Drop a textbox on the Report Footer section
2. Enter =[Page] & " of " & [Pages] into it
3. You can then use Me.Pages to get the number of pages in the report.