Odd "spacer" when pasting into unbound text box

[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.

 

[Allen Browne]

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.

 

[Bart]

Thanks. I ended up using the following:

gstrFreeForm = Replace(gstrFreeForm, Chr(13), "")