Hi 

I am trying to remove the line breaks from a large string that is entered 

by a user. I am using this string in an email that I generate and also 

inserting this string into a memo field in an access database. I am using a 

program to extract this data from the email and put it into a custom 

database on my machine. This program will not accept any data after a line 

break. I have tried replacing the vbcrlf with "" like so



Function ReplaceNewline(str)

	ReplaceNewline=Replace(str, VbCrlf, "")

End Function



But this doesn't seem to work. I am generating a text email and not an html 

email.



Any help would be appreciated

Thanks in advance

Warren