carriage returns not showing up in text field(long text) (1 Viewer)

[MilaK]

Hello,

I've transferred short paragraphs of text from Excel to Access (long text) field and displaying that field in a text-box on a form. The carriage returns (new line) are not visible in a text box, however, if I copy and paste the text into a word document the blank lines between the paragraphs (carriage returns) are visible.

Is there anything I can do in Access to make the new lines visible in the text-box on a form as well?

Thanks,

Mila

 

[moke123]

do you want to show the html markup?
have you tried setting the texbox to plain text while the table field is long text and formatted as rich text.

 

[MilaK]

I've changed the field type to rich text and left the text box as plain text. The indentations are correct, however, <br> appears where the carriage return should be.

Is there anything that I can do to hide <br>?

I've tried changing the text-box to "Rich Text" and it worked for the existing comment, however, when I create new comments in Access it omits the carriage return. Any suggestions?

Thanks,

Mila

 

[isladogs]

Would this work?

Me.textbox = Replace(PlainText(Me.HTMLText,"<br>","")