Re: Reports missing data at end of page, splits text horizontally

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi, Jerry,

I don't mean to sidetrack you, but if I were you I'd get the entire
application the hell out of Access and into Microsoft Word. In Word, you can
do any programming you need in a VBA macro. Word's VBA features include just
about every word processing feature you can think of, and many you can't.

Hope this is helpful, but afraid it's probably not,

Sam

Jerry wrote:
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!

--
Sam

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200603/1
.

Relevant Pages

  • Re: give me a freakin break
    ... > gekko wrote: ... Completes reports but fails to meet deadlines, ... > 3 = Performing at intermediate level. ... The labels that are assigned, however, are constantly shifting because ...
    (misc.writing)
  • Re: labels and envelopes
    ... Thanks Ed for the recommendation. ... Just interesed in labels and envelopes. ... long time--and I've never had to re-write my reports. ... incorporate into my app that would allow users to create and print mailing ...
    (borland.public.delphi.thirdpartytools.general)
  • Flu Drug Makers Change Labels Over Behavior Issue
    ... Flu drug makers change labels over behavior issue ... reports of abnormal psychiatric behavior in some patients. ... and abnormal behavior to the label for its flu drug, ...
    (misc.health.alternative)
  • Problem building custom switchboard
    ... When the main form opens either of the other two, they display slightly offset from the main. ... I tried setting the mode of the two forms mode to popup but the labels and reports stay "under" the popup form which I don't want because it interferes with the users ability to see the labels or reports. ...
    (microsoft.public.access.formscoding)
  • Re: How do I create a macro to boldface text in Access?
    ... It is not possible to edit text in a report. ... In both forma and reports, you can apply a bold face formatting - *but*... ... So, before we get to your specific question of keyboard-controlled boldfacing, we need to clarify whether what you want to do is even feasible. ...
    (microsoft.public.access.macros)