Desperate! Pagination problem

[Guest]

I'm having a problem with a report in Access 2003. The last line of text in
the Detail section gets obscured by the the report footer - you can just see
the tops of the letters peeking above the report footer. I am fairly new to
Access development having just "inherited" this application in mid-May. It
is an Access 2000 application and because of the user community, it must
remain compatible with the earlier version. When the report is run in Access
2000, there is no problem. Only happens in Access 2003. I'm pretty sure the
problem is not in the footer because if I make the report footer not visible,
the text will get obscured by the bottom margin. I have two identical
laptops setup with the same network printer as the default printer. One
laptop runs Access 2000; the other Access 2003. The Access 2000 report is
fine - page breaks are appropriate. The Access 2003 report seems to print 1
extra line of the report before breaking the page.
The "outline" of the report is as follows:

PageHeader (0 height)
GroupHeader0 (force new page after section)
Subreport1 Header (section name)
Subreport1 Detail (section data)
Text boxes
Subreport2
Text boxes
Subreport3
Text boxes
Subreport4
Subreport1 Footer
Detail (0 height)
Page Footer

I verified that all text boxes, etc. have Can Shrink/Can Grow = Yes. Some
of the subreports in the Subreport1 Detail part are only displayed under
certain circumstances (IIF used in Control Source).

I've been scouring the newsgroups etc. but have not seen anyone else with
this problem. I REALLY need to resolve this problem soon as our contract is
ending next week and this is the last issue left.

Thanks for any help anyone can offer.

 

[SA]

Gustafsonkm:

Try changing the height of your detail section and/or other sections.
Access can change heights in increments as small as .0007. Sometimes, minor
changes in those heights can fix problems like this as Access formats the
page.

 

[Guest]

Ok, I've been tweaking the sections of the report (any and all) making them
shorter or taller with no real success. I can make a given set of data get
formated correctly but if I try other data in the report, the problem is
still there. Obviously adjusting for a given dataset is not a real solution.

I also noticed something happening in Access 2000 that I hadn't seen before.
There are textboxes in the Subreport1 Detail that function as labels for the
user data that follows. I sometimes get part of one of these drawn at the
bottom of the page. It prints the "rest" of the textbox at the top of the
next page. Originally I thought it was printed the entire textbox at the top
of the next page but by turning off Grow/Shrink, I now see it's starting the
textbox at the bottom of the page and finishing it at the top of the next
page.

So perhaps my problem with the text getting cut off is not exclusive to
Access 2003 but simply more readily apparent. I've not seen an example of
the user data text getting cut when using Access 2000. Just the labels so
far.

Now I'm really confused. There are a lot of reports in this application
and. AFAIK, this is the only one with this behavior.

 

[Guest]

Clarification:
The label textboxes in the subreport were getting split across the page
break in Access 2000 sometimes. By changing them to Can Grow=No, that
doesn't seem to be happening any longer - if the label doesn't fit it's
getting pushed to the next page. The labels have to be able to shrink
because sometimes there is no user data for that label and we don't want the
label printed then.

When I run Access 2000 next to Access 2003 for the same data, same report,
the user data will get pushed to the next page if there is not enough room
for the sentence in Acess 2000. In Access 2003, it will print the sentence
at the bottom of the page so that the lower part of the text is obscured by
the footer. Sometimes, depending on how the data fills the page, the entire
line is obscured by the footer so the next page begins in the middle of the
sentence.

Example:

Access 2000:
LABEL
<page break>
user data

Access 2003:
LABEL
sentence 1 begins but the lower half of the letters are missing
<page break>
continuation of user data (not the lower half of the letters but
whatever the next word is)

 

[Guest]

I believe I have finally solved this life-consuming issue. For some reason,
the fellow who worked on this application before me scrunched down all the
"user data" textboxes in the report (i.e. made the heights very small).
After I made them all a more reasonable height (0.1972") the pagination
started working the same on Access 2000 and 2003. I tested 288 pages of
report so I'm pretty confident this is now resolved.

Thanks!!!