Odd "spacer" when pasting into unbound text box

  • Thread starter Thread starter Bart
  • Start date Start date
B

Bart

Has anyone ever noticed a small box (spacer) that appears
in the output of a report after pasting data into an
unbound text box of a form that feeds into the report? It
appears to be caused by the hidden format of tabbed or
indented spaces from the original copied text in Word. I
could programatically remove the spaces/indentation from
the string and control the Enter Key Behavior but in some
cases the space is appropriate. Any advice would be
appreciated.
 
If you used a line break instead of a paragraph break in Word, you may find
that this is chr(11) or some such.

If that's what is happening, use the Replace() function to replace Chr(11)
with vbCrLf.
 
Back
Top