473,411 Members | 1,889 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,411 software developers and data experts.

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

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
8 3462
nico5038
3,080 Expert 2GB
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
Kazoo
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
3,080 Expert 2GB
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
Kazoo
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
3,080 Expert 2GB
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
Kazoo
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, 118 views)
May 15 '08 #7
Kazoo
9
Anyone get a chance to look at this yet?
May 15 '08 #8
Kazoo
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

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

Similar topics

4
by: Howard Martin | last post by:
I have a page at http://www.no1hastings.com.au/new/index.html designed for 800 x 600 resolution and where nearly all the elements are positioned using CSS. The elements are lined up to the left...
4
by: Nhmiller | last post by:
Access seems to always generate a second page, which is blank, to my one page report. How do I delete the second page? Thanks. Neil Cat Paintings At Carol Wilson Gallery...
2
by: Graham Feeley | last post by:
I have looked for examples using " Double Columns per page but have found none. I have created a Query from a table, they consist of only 2 Fields namely Movie and Id What I am trying to achieve...
1
by: monskie | last post by:
Hello to all, I have a problem which could be trivial to you guys. This concerns opening several crystal reports on the a crystal viewer on an ASPX page by calling window.open. My...
4
by: jmalvika | last post by:
Hi all, I'm trying to generate an excel report from an ASP web page using .. "response.ContentType = "application/vnd.ms-excel" .... I need to add a custom header & footer to the excel...
13
by: Greg | last post by:
Most suggestions on this topic recommend to use a page footer and make it visible only on the last page. My problem is that the footer is half of the height of a page which means the detail would...
2
by: microsoft . public . sqlserver | last post by:
I am a Web developer. I am new to VB 6.0 and Crystal Report. I have joined an organisation where there is an application running(developed in VB6 and crystal report 7). I have to modify one report....
1
by: Ron | last post by:
Hi All, I'm using A2K and need to print a specific pre-printed form. I know that once I have that report on a particular computer screen I can select "Page Setup" and change the margins to get...
5
by: andi | last post by:
Hello, I created a report in Acess2000 and now it repeats itself three times. At first I thought its a problem with the page margins but that would mean that empty or almost empty pages would...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.