On 6 jan, 17:28, Joel wrote:
use replace3 to remove the chr10

MyString = replace(MyString,chr(10),"")



"joeeng" wrote:
Why does a multiline string value from a form textbox display the linebreaks
{chr(10)} as little squares when saved to a cell? *Can these little squares
be suppressed from the cell viewing by using a different ascii character for
the linebreak?- Tekst uit oorspronkelijk bericht niet weergeven -

- Tekst uit oorspronkelijk bericht weergeven -

If you want the linebreak kept use:

MyString = replace(MyString,chr(10),vbNewLine)

HTH,

Wouter