To print 'Contd. On Next Page...[page number]" what will be the code incase the report is more than 1 page ?
I got the answer after my several try. Just place an unbound text box at the bottom of your report and type the following code into it.
=IIf([Page]<[Pages],"Contd. On Next Page..." & [Page]+1,"")
If report is more than 1 page, it will show you text Cond..On Next Page...2 at the first page. And likewise on the next page if some more pages are there. It will show nothing if report is only on one page also will not show on the last page.
Can somebody answer to my second question from the thread?