Hard returns as boxes on linked, imported data.

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

Guest

Is there a way to keep hard returns when Excel or Word data is linked or
imported into Access? The hard returns show up as boxes.
 
Georgie said:
Is there a way to keep hard returns when Excel or Word data is linked or
imported into Access? The hard returns show up as boxes.
Click to expand...

Access requires both a Carriage Return AND a LineFeed character. When you see
the little black boxes it usually means you have only one or the other. You
could run an update query using the Replace() function to replace all instances
of Chr(10) with Chr(13) & Chr(10).
 
Back
Top