Hard returns as boxes on linked, imported data.

[Georgie]

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.

 

[Rick Brandt]

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.

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).