Missing spaces in memo field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a memo field which I would like to have print on a report the same way
that it looks going in on the form. As near as I can tell, the field boxes
on both the report and the form are the same size, and the font and
formatting are identical. I want the secretary to be able to line up words
which have to line up in the final document within the memo box, and have
them line up in the report. Right now, it seems like Access is trimming a
somewhat random number of spaces from each line, resulting in a ragged edge
for a piece of the memo that should line up. I don't want to use separate
fields, because not every memo field of this type has the parts that need to
line up.

What's happening to the spaces? Can I make access store them all?

Thanks.
 
r. howell said:
I have a memo field which I would like to have print on a report the same way
that it looks going in on the form. As near as I can tell, the field boxes
on both the report and the form are the same size, and the font and
formatting are identical. I want the secretary to be able to line up words
which have to line up in the final document within the memo box, and have
them line up in the report. Right now, it seems like Access is trimming a
somewhat random number of spaces from each line, resulting in a ragged edge
for a piece of the memo that should line up. I don't want to use separate
fields, because not every memo field of this type has the parts that need to
line up.

What's happening to the spaces? Can I make access store them all?
Click to expand...


Hmmm, I've never noticed this effect before. Weird!?

It seems that the rules (AXP) for wrapping long lines are
more complex than I thought. If a long line of spaces occur
at a line wrapping position the spaces are not displayed.
It even went so far as to move a previous word to the next
line and capitalize the first letter after a period
space(s).

I was able to get it to leave most of it alone by using
Ctrl+Enter to end a line instead of using a bunch of spaces
to get to the start of the next line. But I suspect that
this effort is largely doomed because the WYSIWYG can only
go so far considering that the screen and printer
resolutions are different.
 
Back
Top