Formatting contents of a text box. . . .

I want to remove all extra carriage returns from a text box, but when I do I end up with a "" What is this symbol?  How do I remove it?

Here's my code:

Text = Replace(Text, Chr$(8) & vbCrLf, "")
adamkushnerAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
DiveblueConnect With a Mentor Commented:
I thought I gave you the answer as well
0
 
DiveblueCommented:
Text = Replace(Text,vbCrLf, "") should work to remove crlf's but I get the impression you only want to remove crlfs that do not have text before them.

What is the purpose of your use of chr(8)??

can you explain your need in more detail?

thanks,
Scott
0
 
igfpCommented:
This makes no sence. Char 8 is the backspace! maybe it was char 13! that's the line breaking, Diveblue is right!
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
adamkushnerAuthor Commented:
Yes, I think your correct.  Should have been 13!

Thanks,

Who should get the points?
Diveblue identified the problem, igfp, the answer?


0
 
adamkushnerAuthor Commented:
Yes, thank you.
0
 
igfpCommented:
Yes, Diveblue gave you the answer, point go to him! I deserve no credit for changing a char for crying out loud! :p
0
All Courses

From novice to tech pro — start learning today.