line break character
vbnewline adds a chr(13) & Chr(10)
"RadarEye" wrote:
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
|