Results 1 to 4 of 4
  1. #1
    kfinpgh is offline Novice
    Windows XP Access 2003
    Join Date
    Jun 2006
    Posts
    7

    Page numbering glitch

    I created several reports that check for the page bottom before possibly printing a group header. This avoids an orphan group header (group header with no detail) at the bottom of a page. The code I used for this came from Microsoft.

    Now, one report shows 2 more printed pages than the total pages (ie: 149 of 147 pages) on the last page. The 149 is the true page count, but the 147 is not. Access must lose track of the total page numbers as it's formatting the report. That report seems to have a problem with any page count.

    It's a minor thing, but I know my managment will pick at that as if it was a major thing. Other reports using a similar technique work properly.

    I don't use a subreport, but the detail for each group can vary. The detail section and its controls can grow/shrink. There is one line per detail so there should not be a gap problem between detail lines. There are some blank records in the query I use as group counters, so allowing the detail section and controls to shrink/grow works well in minimizing white space.

    I also added code to make some of the group header controls not visible if a group is continued to the next page. I replace them with a "continued ..." label. The group header and its controls cannot grow/shrink and the page problem remained after I deleted that code as a test.



    This report also has a page numbering problem if it's told to render the detail and other controls not visible (summary mode).

    Any ideas to find and fix the problem?

  2. #2
    kfinpgh is offline Novice
    Windows XP Access 2003
    Join Date
    Jun 2006
    Posts
    7

    [RESOLVED] page numbering glitch

    I use the ifbottom function (available from Microsoft's web site) in determining if there is enough room for the header to print. I told it to use a floating point number (single or double) instead of integer and set the number to 9.4. I already have .5 inch as the top and bottom margins and the page footer is 2 lines. The group header is about .6 inches so that works out well.

  3. #3
    Join Date
    Jun 2006
    Posts
    3

    Re: [RESOLVED] page numbering glitch

    Quote Originally Posted by kfinpgh
    I use the ifbottom function (available from Microsoft's web site) in determining if there is enough room for the header to print. I told it to use a floating point number (single or double) instead of integer and set the number to 9.4. I already have .5 inch as the top and bottom margins and the page footer is 2 lines. The group header is about .6 inches so that works out well.
    I did a search on "ifbottom", "if_bottom" on microsoft.com and msdn.microsoft.com with no results.
    Can you point me to it?
    Thanks

  4. #4
    kfinpgh is offline Novice
    Windows XP Access 2003
    Join Date
    Jun 2006
    Posts
    7
    i found that function while looking for widows and orphans, the term used for the few words in a sentence that flow to the next page. the knowledge base has a lot of articles regarding all sorts of short cuts.

    I solved my problem by tinkering with the page length number in the function used in the onprint property of the header. It took a few tries, but it worked.

    You may also look for page numbering, pages, headers, or other similar terms.

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

Similar Threads

  1. Replies: 1
    Last Post: 03-12-2009, 09:55 AM
  2. Access and Web page
    By mahlambane in forum Access
    Replies: 1
    Last Post: 11-18-2008, 11:43 AM
  3. Numbering records
    By knightjp in forum Database Design
    Replies: 0
    Last Post: 08-17-2008, 07:07 AM
  4. Auto Numbering
    By rkruczk in forum Forms
    Replies: 0
    Last Post: 10-09-2006, 04:25 AM
  5. Page Footer Top
    By RHall in forum Reports
    Replies: 3
    Last Post: 12-15-2005, 09:35 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