Carriage Returns in Memo fields

[Gillian Steele]

I'm trying to import data into a memo field by running an append query. The
data is to be imported as
if it was entered with separate lines in the memo field. I have tried
inserting chr(13)s into the string that is being appended into the memo
field but when appended, the data displays with a square box in place of a
carriage return/line feed. I would like to import the data so that data is
displayed in separate lines within the memo field.

Can some one please advise how this can be done? I have tried using chr(10)
as well but same results. Thanks.

[pietlinden]

Gillian Steele wrote:

I'm trying to import data into a memo field by running an append query. The
data is to be imported as
if it was entered with separate lines in the memo field. I have tried
inserting chr(13)s into the string that is being appended into the memo
field but when appended, the data displays with a square box in place of a
carriage return/line feed. I would like to import the data so that data is
displayed in separate lines within the memo field.

Can some one please advise how this can be done? I have tried using chr(10)
as well but same results. Thanks.

did you try vbCrLf?

[David W. Fenton]

"Gillian Steele" <gs*****@spiceisle.comwrote in
news:12*************@corp.supernews.com:

I'm trying to import data into a memo field by running an append
query. The data is to be imported as
if it was entered with separate lines in the memo field. I have
tried inserting chr(13)s into the string that is being appended
into the memo field but when appended, the data displays with a
square box in place of a carriage return/line feed. I would like
to import the data so that data is displayed in separate lines
within the memo field.

Can some one please advise how this can be done? I have tried
using chr(10) as well but same results. Thanks.

On Windows, the line terminator is Chr(13) followed by Chr(10).

There is a built-in VBA constant, vbCrLf, that you can use to save
the time and processing power of testing against those two
characters.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

[Terry Kreft]

Chr(13) is a carriage return
Chr(10) is a line feed

You need a carriage return and line feed, either Chr(13) & Chr(10) or the
intrinsic constant vbCrLf.
--

Terry Kreft
"Gillian Steele" <gs*****@spiceisle.comwrote in message
news:12*************@corp.supernews.com...

I'm trying to import data into a memo field by running an append query.

The

data is to be imported as
if it was entered with separate lines in the memo field. I have tried
inserting chr(13)s into the string that is being appended into the memo
field but when appended, the data displays with a square box in place of a
carriage return/line feed. I would like to import the data so that data

is

displayed in separate lines within the memo field.

Can some one please advise how this can be done? I have tried using

chr(10)

as well but same results. Thanks.