Results 1 to 3 of 3
  1. #1
    MSKI is offline Novice
    Windows 10 Access 2007
    Join Date
    Aug 2016
    Posts
    1

    Post How can I reference Page number control for Table of Contents in Access 2007?

    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.

  2. #2
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    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.

  3. #3
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    The page number is a property of the Report. You have Page and also Pages.

    In an unbound control
    Code:
    ="Page " & [Page] & " of " & [Pages]
    The trick is retrieving the information during the correct Format event.

    So if you need to display the information somewhere unconventional, you may need to use VBA.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 10
    Last Post: 06-19-2014, 01:51 AM
  2. table of contents off by one page
    By crobaseball in forum Access
    Replies: 8
    Last Post: 05-13-2014, 01:47 AM
  3. Replies: 7
    Last Post: 12-06-2013, 03:11 PM
  4. Replies: 4
    Last Post: 09-04-2013, 06:40 AM
  5. Replies: 5
    Last Post: 10-19-2010, 08:02 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums