By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,064 Members | 1,388 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,064 IT Pros & Developers. It's quick & easy.

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

P: 9
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.
May 14 '08 #1
Share this Question
Share on Google+
8 Replies


nico5038
Expert 2.5K+
P: 3,072
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)
May 14 '08 #2

P: 9
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.
May 14 '08 #3

nico5038
Expert 2.5K+
P: 3,072
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)
May 14 '08 #4

P: 9
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.
May 14 '08 #5

nico5038
Expert 2.5K+
P: 3,072
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)
May 14 '08 #6

P: 9
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
File Type: zip TestDB.zip (2.58 MB, 96 views)
May 15 '08 #7

P: 9
Anyone get a chance to look at this yet?
May 15 '08 #8

P: 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.
May 16 '08 #9

Post your reply

Sign in to post your reply or Sign up for a free account.