How do I concatenate text incl a CRLF into MSAccess memo field?

  • Thread starter Thread starter James F
  • Start date Start date
J

James F

I am combining several old data items into a single Summary memo field. I
would like to be able to add a label for the data and then have each data
item to be inserted on a newline.

Thanks for your help.
 
Use the concatenation of Chr(13) and Chr(10) to insert the CrLf characters.

"Text1" & Chr(13) & Chr(10) & "Text2 on new line"
 
Thanks Ken. That works! Cheers!

Ken Snell (MVP) said:
Use the concatenation of Chr(13) and Chr(10) to insert the CrLf characters.

"Text1" & Chr(13) & Chr(10) & "Text2 on new line"
Click to expand...
 

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

Extract Data from Memo Field 2
Force data type from Text to Memo in a simple Make Table Query 1
update query - memo field 5
Combine fields Text to Memo 1
Selecting Distinct Memo Fields 1
how can I specify text criteria when querying a memo field 1
How can I convert text field to memo field in a query 10
MSACCESS 97 APPLICATION ERROR CONVERTING FROM TEXT TO MEMO 4

Back
Top