Express "return char" or "Linefeed"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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))
 
Back
Top