Mutli-line text box outputting funny characters

[cbrf23]

I have a text box on a form for adding notes to the form.

The text box is set up so that hitting enter while typing inside it adds a carriage return. Enter behavior and multiline are set to True.

When I tested things at home, on excel 2010, hitting enter while typing in the textbox resulted in a carriage return/line feed, and when the text box data was entered into a cell it was the same as dislplayed. Perfect, exactly what I want.

But, when I got to work this morning, excel 2003, I found that if I type in my textbox and hit enter, I get multiple lines in the textbox that look fine. BUT, when the string is output to a cell, i get a carriage return but the last character of the line (before the carriage return) is a funny little square character...

Whats the deal? And does anyone know how to fix this?

I tried to paste the text from excel into this post, but the squares didnt display....

 

[mikerickson]

What is the little square character, Chr(13)? or something more exotic?

 

[cbrf23]

I found the solution in another thread here.

Seems that the little square was indeed the chr(13) symbol. I did not know that.

This solution works, but I dont really understand why I was getting those symbols in the first place. (using font arial, fontstyle normal, size 12)

In my code, I replaced:

strNote = Me.txtNote.Text 'txtNote is the name of my textbox...

with

strNote = Replace(Me.txtNote.Text, vbCrLf, vbLf)