Report's Second page changes it's margin to be higher

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Kazoo
    New Member
    • Mar 2008
    • 9

    #1

    Report's Second page changes it's margin to be higher

    I have a report that has one record per page. It has to print on a pre-printed application so the fields have to print perfectly. All of the pages except for the second record prints correctly. Whenever the 2nd page prints the Margin goes up by about one row of text. It occurs regardless of the data that is in the 1st 2nd or 3rd records.

    Anyone know what the problem could be and how to fix it?

    Any help would be appreciated.
    Thank you.
  • nico5038
    Recognized Expert Specialist
    • Nov 2006
    • 3080

    #2
    Hmm, probably the details section is just some points too "high".
    You could try to move the lower "line" up as much as possible and make sure that the paging is done using the "Force New page" property.

    Nic;o)

    Comment

    • Kazoo
      New Member
      • Mar 2008
      • 9

      #3
      Looked at that already. The report has over 80 pages and the error only occurs on the 2nd page. And regardless of what record I put in there it still occurs on the 2nd page.

      Comment

      • nico5038
        Recognized Expert Specialist
        • Nov 2006
        • 3080

        #4
        Hmm, then it could be data related, what happens when you exclude the first record and what when you exclude the second record?

        Nic;o)

        Comment

        • Kazoo
          New Member
          • Mar 2008
          • 9

          #5
          Originally posted by nico5038
          Hmm, then it could be data related, what happens when you exclude the first record and what when you exclude the second record?

          Nic;o)

          It doesn't seem to be data related as I can delete the existing 1st and 2nd record and it still has the same problem. Actually I deleted the first 10 records, and it still messes up the 2nd record.

          Comment

          • nico5038
            Recognized Expert Specialist
            • Nov 2006
            • 3080

            #6
            Can you make a small sample .mdb with the table(s) and the report with the problem, so I can have a look?
            Just create a comment here and add afterwards the attachment.

            Nic;o)

            Comment

            • Kazoo
              New Member
              • Mar 2008
              • 9

              #7
              Originally posted by nico5038
              Can you make a small sample .mdb with the table(s) and the report with the problem, so I can have a look?
              Just create a comment here and add afterwards the attachment.

              Nic;o)
              Nevermind. After I editied it I got the attach option. File is to big though so I'll shrink it down and then post it.
              -----------------------------
              Okay, here is the file.
              Attached Files
              Last edited by Kazoo; May 15 '08, 06:09 PM. Reason: Attaching file

              Comment

              • Kazoo
                New Member
                • Mar 2008
                • 9

                #8
                Anyone get a chance to look at this yet?

                Comment

                • Kazoo
                  New Member
                  • Mar 2008
                  • 9

                  #9
                  For those that care, I figured this out.

                  The PageHeader on the report was showing....it was empty, but the bar was still there. Once I removed it it was fine. It still doesn't make sense as to why it only effected the 2nd page though, but hey, that's Access for you.

                  Comment

                  Working...