Removing VbCrLf from a variable string

[craigachan]

Hi all,

I've read through all the 'Remove CR's' but am still confused on how to do it.

I have a field that may have a variable string. What I want to do is remove the vbCrLf from it, where ever it is. How do I do this?

Thanks for your help.

 

[motleyjew]

I think you can you use the replace function:

Replace([FieldName], vbCrLf, "")

Gregg

 

[craigachan]

Thanks so much Gregg