Line Break

[Exodus]

How Can I remove line breaks in a string.

 

[RuralGuy]

How about:
Replace(YourString,chr(10),"")
Replace(YourString,chr(13),"")
Replace(YourString,vbCrLf,"")

 

[Exodus]

How Do I use that? I 'm trying to get the results return in a query.

 

[Exodus]

This Is What I came up with let me know if it is wrong.

Del: Replace([DeliveryContactInformation],Chr(13) & Chr(10)," ")

 

[RuralGuy]

I do not know if you are trying to eliminate both CR and LF characters but lets assume you are. You could either create your own function and then make a new field with NewField: YourFunction([OldField])

Or you could do it with two new fields:
NoCrField: Replace([YourField],vbCr,"")
NoCrLfField: Replace([NoCrField],vbLf,"")

 

[RuralGuy]

You do not need to subsitute a space. You can use a zero length string "".

 

[Exodus]

right but I wanted the space other wise the next line is right next to the last character of the previous line.