468,321 Members | 1,820 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,321 developers. It's quick & easy.

Carriage Returns in Memo fields

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.

Sep 25 '06 #1
3 9631

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?

Sep 25 '06 #2
"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/
Sep 25 '06 #3
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.

Sep 27 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Dave | last post: by
1 post views Thread by I am Sam | last post: by
1 post views Thread by howard w | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.