Remove Chr(10) symbol from a text box.

[Aussie Grid]

I need to remove the Chr(10) symbol (a square) from a multi line text box. The text box is on a form and then the contents are entered into a comment box by a button.
The "returns" are not sighted until entered into the comment.
The nature of the data requires a new line in the text box like:
Bill
Bob
Ben
etc.

Any and all help appreciated.

Aussie Grid

 

[diddi]

have you tried ...

strResult=Replace(textbox1.value,chr(10),"")

 

[Aussie Grid]

Thanks didi, but I can't seem to find the correct place to put it.
I would appreciate some guidance please.

Aussie Grid