Removing Carriage Returns

[Smythe32]

Hi All,

I am trying to remove carriage returns from a text field via some code.

Here is an example of what I am up against.

The field streetname contains the little square box that I believe is a
carriage return.

So, the field will have text, the little square box and more text. I
am trying to remove whatever that little box is. I tried to paste it
into this but it just moved the latter text to a new line, hence the
carriage return.

Any help would be appreciated.

Thanks

[Rick Wannall]

if string s contains your address, one of the following will do the trick:

(most likely case first)

s = replace(s, vbcrlf, ", ") 'if it's a CR/LF pair, you'll
get a comma instead

or

s = replace (s, chr(10), ", " 'if it's just a Line Feed, you get a
comma instead

or

s = replace (s, chr(13), ", " 'if it's just a Carraige Return, you
get a comma instead

[Smythe32]

Rick,

Thanks so much and I definitely was making that much more difficult
than it needed to be.

It was the 2nd one that did the trick.

Thanks Again,

[Rick Wannall]

Great.

By the way, there are constants for those other things. I just forgot about
them? vbCr and vbLf are chr(13) and chr(10) respectively.