G
Guest
I have a couple of reports giving me GRIEF! Aside from the hassle of finding
the lowest common denominator for printer layouts regarding borders, page
widths and lengths, the output often misses the last line of text before a
page break.
These reports are not reports in the traditional sense...they are emulating
government mandated paper forms and have many data elements on them. I use
Headers and Footers. I use sub reports within some of the pages. Many of the
data fields are Memo fields. There are labels obviously mixed in between many
of the fields. Most of the reported fields are set to be able to grow, a few
can shrink. The print size oftens varies from 8 to 10 or 12 on the same page.
Bold and normal fonts are also used as needed.
I see three problems, sometimes on the same report. The worst problem is
that data can be lost at the bottom of a page when a line or part of a line
should be carried over to the top of the next page. This means my users must
constantly proof read the output, not making them happy since they proof read
the input!
The second problem is that a label, be it a single word or line or multiple
lines of text may be split horizontally with the upper part of the characters
on the bottom of one page and the bottoms on the following page.
The third problem is that anything in bold print will take up more printed
space than it does in layout mode. For many bold labels, I have had to make
them text fields that can grow and then populate them with literals in the
OnFormat event. Otherwise, the label is often cut off at some point on its
rightmost edge.
It is as though the report writer simply doesn't know when the page is about
to end. The footers are always intact, only the body of the report is
affected.
I'd sure appreciate some guidance here. By the way, this access app is
developed using access 2003, in 2002-2003 format. Prior to being
deployed, it is transferred to an access 2002 system for compilation into an
mde. When deployed, my customers use the acess 2002 runtime.
Thanks for any ideas!
the lowest common denominator for printer layouts regarding borders, page
widths and lengths, the output often misses the last line of text before a
page break.
These reports are not reports in the traditional sense...they are emulating
government mandated paper forms and have many data elements on them. I use
Headers and Footers. I use sub reports within some of the pages. Many of the
data fields are Memo fields. There are labels obviously mixed in between many
of the fields. Most of the reported fields are set to be able to grow, a few
can shrink. The print size oftens varies from 8 to 10 or 12 on the same page.
Bold and normal fonts are also used as needed.
I see three problems, sometimes on the same report. The worst problem is
that data can be lost at the bottom of a page when a line or part of a line
should be carried over to the top of the next page. This means my users must
constantly proof read the output, not making them happy since they proof read
the input!
The second problem is that a label, be it a single word or line or multiple
lines of text may be split horizontally with the upper part of the characters
on the bottom of one page and the bottoms on the following page.
The third problem is that anything in bold print will take up more printed
space than it does in layout mode. For many bold labels, I have had to make
them text fields that can grow and then populate them with literals in the
OnFormat event. Otherwise, the label is often cut off at some point on its
rightmost edge.
It is as though the report writer simply doesn't know when the page is about
to end. The footers are always intact, only the body of the report is
affected.
I'd sure appreciate some guidance here. By the way, this access app is
developed using access 2003, in 2002-2003 format. Prior to being
deployed, it is transferred to an access 2002 system for compilation into an
mde. When deployed, my customers use the acess 2002 runtime.
Thanks for any ideas!