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

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

Ken Snell \(MVP\)

Use the concatenation of Chr(13) and Chr(10) to insert the CrLf characters.

"Text1" & Chr(13) & Chr(10) & "Text2 on new line"
 
J

James F

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