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

  • Thread starter One Handed Man [ OHM ]
  • 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
 
V

Van T. Dinh

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

Nearly there. You need 13 & 10 in this order.
 
O

One Handed Man [ OHM ]

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...
 
K

Ken Snell

Line breaks in ACCESS are a combination of ASCII characters 13 and 10 (in
that order).
 

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

Text and Memo field concatenation - Line break (Access 2007) 4
Enter new line in rich text memo field 4
Restoring line breaks in memo field 2
Line breaks in text imported by ODBC into Memo Fields 1
Import text with line breaks 1
append text to end of multi-line textbox 9
Formatting text in a label or text box 3
Line Break in Text box with control source 3

Top