to correct this and remove carridge returns in Access you can use the following.
Replace([data],Chr(10),"")
CHR(10) = LF
CHR(13) = CR
you might need to replace both.
you can put that command in an update query update to field.
** EDIT: This is how to do it in Access 2003, not positive if it will work in previous version but worth a try.
Replace([data],Chr(10),"")
CHR(10) = LF
CHR(13) = CR
you might need to replace both.
you can put that command in an update query update to field.
** EDIT: This is how to do it in Access 2003, not positive if it will work in previous version but worth a try.