Express "return char" or "Linefeed"

B

Bill Sturdevant

I have some code that imports values from an Excel spreadsheet.
Unfortunately, some of the folk who put the data in the spreadsheet put "hard
returns" in some of the cells.

I need either a query or some code to identify when this occurs. Perhaps I
am too tired to see the obvious, because this seems so simple, but how do I
test for a "return" or "line feed" in either code or a query?
 
J

John Nurick

Hi Bill,

Newlines in Excel cells consist of the ASCII linefeed character,
Chr(10).

You can change them to something Access textboxes will recognise by
using this in an update query:

Replace([MyField], Chr(10), Chr(13) & Chr(10))
 
Top