Results 1 to 2 of 2
  1. #1
    herbc0704 is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Jul 2010
    Posts
    16

    Headers that span more than a page


    I created a report that will create inventory tags for locations in my warehouse. Each header is a loaction with detail listing of inventory. Sometimes the detail of the inventory can span 2 to 3 pages. Is there a way whether through formatting or VBA that if the location header is more than one page the header could have a note that says something like continued or page 1 of 2?

  2. #2
    hertfordkc is offline 18 year novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    481

    From your post, it seems that you don't know in advance whether

    a report will involve a header spanning more than one page. A long time ago, I had to create a report that involved a similar problem. I no longer have access to the DB. However, I believe that the problem was solved by using one of the report events involving repagination. I'm not on my Access box right now, so I'll have to take a look and get back to you if I can find more specific info, or reverse my dementia.

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

Similar Threads

  1. Control Page Headers with VBA?
    By FL_Boy in forum Reports
    Replies: 3
    Last Post: 12-22-2011, 03:49 PM
  2. Sub report page headers
    By rahayes in forum Reports
    Replies: 3
    Last Post: 11-11-2011, 04:21 AM
  3. Page Break in Report Headers
    By JonathanT in forum Reports
    Replies: 8
    Last Post: 06-30-2011, 10:37 PM
  4. Too many page headers for one report?
    By Swilliams987 in forum Reports
    Replies: 0
    Last Post: 02-14-2011, 11:36 AM
  5. SQL - How to make Access understand time-span?
    By Jimmy_XistenZ in forum Queries
    Replies: 4
    Last Post: 10-12-2010, 12:21 PM

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