Access VBA - Find and Replace text for Line Breaks returns weird blocks in my Word document
<p>In my Access form a user can enter some text in a text block. Usually there are multiple line breaks in this text (so in the properties of the textbox the enter functionality is changed to return a line break instead of going to another record). </p>

<p>The text that a user types in the form will replace some text in a word document using the VBA find and replace function:</p>

<pre><code>With objWord.Selection.Find
        .Forward = True
        .Wrap = 1
        .ClearFormatting

        .Execute2007 FindText:="{IndexText}", ReplaceWith:=NewIndexText, Replace:=2 'string is less than 255 so replace it

    End With
</code></pre>

<p>This works fine, though when the user uses line breaks in their text I get these weird blocks in my Word document:</p>

<p><a href="https://i.stack.imgur.com/VlDO9.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/VlDO9.png" alt="enter image description here"></a></p>

<p>How can I get to show the Line breaks correctly without the blocks (and also without the Line break symbol).</p>

<p>P.S. I also build in code for handling text with more than 255 characters but just didn't post the code since its unnecessary for this question.  </p>