Conveting hard return in memo field

[Bob Smith]

I have a linked table to sql server that uses the text
datatype and in that field it has stored hard
returns throughout text. 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. I
have tried to do a replace(field,chr(13),chr(xx)) and it
works when I replace it with a letter, but can't seem to
get a hard return. Any help would be appreciated

 

[fredg]

I have a linked table to sql server that uses the text
datatype and in that field it has stored hard
returns throughout text. 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. I
have tried to do a replace(field,chr(13),chr(xx)) and it
works when I replace it with a letter, but can't seem to
get a hard return. Any help would be appreciated

In Access, a hard return is chr(13) & chr(10) in that order.

If the return character in the field is chr(13) use:

Replace([MemoField,chr(13),chr(13) & chr(10))

 

[Guest]

Thanks Fred, exactly what I needed worked like a charm!!!!

-----Original Message-----

I have a linked table to sql server that uses the text
datatype and in that field it has stored hard
returns throughout text. 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. I
have tried to do a replace(field,chr(13),chr(xx)) and it
works when I replace it with a letter, but can't seem to
get a hard return. Any help would be appreciated

In Access, a hard return is chr(13) & chr(10) in that order.

If the return character in the field is chr(13) use:

Replace([MemoField,chr(13),chr(13) & chr(10))

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.