I have been trying to reference (display) a page number in a Table of Contents Report for a printed report and have not been successful. I have been unable to find the correct Control Source coding.
I have been trying to reference (display) a page number in a Table of Contents Report for a printed report and have not been successful. I have been unable to find the correct Control Source coding.
I see what you are asking but need clarification. Is the Table of Contents a separate Report or the first page of the main report(so all in 1 report)? Do you have data in the report that will pagebreak on a group or field value? Can you give examples of your data and table of contents.
The page number is a property of the Report. You have Page and also Pages.
In an unbound controlThe trick is retrieving the information during the correct Format event.Code:="Page " & [Page] & " of " & [Pages]
So if you need to display the information somewhere unconventional, you may need to use VBA.