Microsoft Access replace function for Carriage Return or Line feeds, SQL code
How to remove line break from microsoft access field in a table
CR & LF =. Chr(13) & Chr(10) in code…
Here is the code to use:
replace([Field1], chr(10), ” “)
Microsoft Access replace function for Carriage Return or Line feeds, SQL code
How to remove line break from microsoft access field in a table
CR & LF =. Chr(13) & Chr(10) in code…
Here is the code to use:
replace([Field1], chr(10), ” “)