Problem: lines of report text are split???

[Lewis Moseley]

This is a new one on me.

I have a report. The detail section of the report contains a
SubReport and also has a row of text boxes and labels in a single line
above the SubReport and another row of text boxes and labels below the
SubReport. The SubReport will contain a variable number of line
items.

In Properties, both the Detail Section and the SubReport have "Can
Grow"=Yes.

When I preview or print the report, in SOME cases where the line of
print in the Detail Section below the SubReport occurs as the last
line on the page, that line will be split into two pieces
horizontally. Literally split... the upper part of each character in
the line is printed at the bottom of the page, while the lower part of
each character in the line is printed at the top of the next page. In
other cases, still where the line of print in the Detail Section below
the SubReport occurs as the last line on the page, that line will
print normally.

The occurance of the splitting is repeatable so long as I do not
change the underlying data. If I add an item or two to the detail
table, then the error will occur on different pages... or not at all.

Does anyone have a suggestion of how to stop this?

Thanks in advance!

 

[Allen Browne]

Hi Lewis.

Sounds like there is a problem with the font metrics, or with the printer
driver's interpretation of the font metrics. (Access does use the print
driver, even for a preview.)

Try using a really standard font, such as Arial or Times New Roman.
If the problem is solved, you can choose another font that matches the look
you want.

If the problem is not solved, try a completely different printer driver.
(You don't have to buy another printer, just install another driver.) If
that solves the problem, see if you can get an update for your printer
driver.

If you are still stuck, your video driver affects how things display also,
but I would not expect that to be the issue here. You could try booting into
safe mode (uses vanilla VGA), and if that solves the problem get an updated
video driver.

HTH

 

[Lewis Moseley]

Thanks for your reply, Allen.

The font is plain old Microsoft Arial. I am using a Brother printer
with a WinXP-certified driver, but I will see if there is an update.
Thanks for that tip.. I was thinking Access rather than printer
driver.

The problem occurs both on the on-screen preview and on the paper
printout, if that makes a difference.

The strange part to me is that it ONLY affects this one single line of
text, the one below the SubReport in the detail section. I have tried
various twiddlings, like changing the height of the controls on that
line, changing the location of the line (the "TOP" parameter), and
etc, and while that changes the place where the error happens, on a 75
page report it always happens once or twice.