Preserving Line breaks when importing text into multi line text boxes.

  • Thread starter Thread starter One Handed Man [ OHM ]
  • Start date Start date
O

One Handed Man [ OHM ]

Hi,

I am importing a CSV file into access and three of the fields are going into
Memo type fields. This all workds find, but I'm not sure what control
characters to embed in the strings to force a new line in access.

I have tried ASCII ( 10 ) (10) & (13) (9) ( 11).

None of these work. Can someone help ?

Cheers
 
(newgroups trimmed. Please restrict to a max. of 3 relevant newsgroups)

Nearly there. You need 13 & 10 in this order.
 
Many thanks - works fine now.



Van T. Dinh said:
(newgroups trimmed. Please restrict to a max. of 3 relevant newsgroups)

Nearly there. You need 13 & 10 in this order.
Click to expand...
 
Line breaks in ACCESS are a combination of ASCII characters 13 and 10 (in
that order).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Line breaks in text imported by ODBC into Memo Fields 1
Import text with line breaks 1
Text and Memo field concatenation - Line break (Access 2007) 4
Importing Text Files Into Access 1
Enter new line in rich text memo field 4
line break icon 1
Line Break in Text box with control source 3
Restoring line breaks in memo field 1

Back
Top