I have to strip any carriage returns from memo fields before Inserting or 

updating records in my Access data. I can do it with single quotes and 

substitue a character that will not mess up the UPDATE or INSERT statement 

but I cannot seem to figure out how to do it with carriage returns. I have 

been trying versions of CHR(13) to get at it but no luck.



You consideration is very much appreciated

Add this function to your code and then call it when inserting/updating.



Hope this helps

Tony



<%

Function AddBreaks (GetTheStr) 

for i = 1 to len(GetTheStr)

	If len(GetTheStr) - i > 1 and mid(GetTheStr, i, 1) = chr(13) then

		phrase = phrase & "<br>"

	else

		phrase = phrase & mid(GetTheStr, i, 1)

	end if

next

AddBreaks = phrase

End Function

%>







> I have to strip any carriage returns from memo fields before Inserting 

or 

> updating records in my Access data. I can do it with single quotes and 

> substitue a character that will not mess up the UPDATE or INSERT 

statement 

> but I cannot seem to figure out how to do it with carriage returns. I 

have 

> been trying versions of CHR(13) to get at it but no luck.

> 

> You consideration is very much appreciated

> I have to strip any carriage returns from memo fields before Inserting 

or 

> updating records in my Access data. I can do it with single quotes and 

> substitue a character that will not mess up the UPDATE or INSERT 

statement 

> but I cannot seem to figure out how to do it with carriage returns. I 

have 

> been trying versions of CHR(13) to get at it but no luck.

> 

> You consideration is very much appreciated



If you're using a textarea tag, try setting wrap to off.