Converting hard returns

[Bob Smith]

I have a linked table to sql server that uses the text
datatype and in that datatype it has built in hard
returns. when bringing them into access via a query they
show up as a square character. Access is not recognizing
them as a hard return and I need it to. Any help would be
appreciated

 

[John Nurick]

Hi Bob,

Probably the "squares" are CR - Chr(13)- or LF - Chr(10) - characters;
Access textboxes use the pair of characters CR+LF.

Ordinarily (and with recent versions of Access) you can use the
Replace() function in an update query, e.g.
Replace([MyField], Chr(13), Chr(13) & Chr(10))
and if you can update the SQL server table that's probably the simplest
way to go.