line breaks

  • Thread starter Grimble Gromble
  • Start date
G

Grimble Gromble

I'm trying to use an update query to concatenate several
text lines into a single memo field with line breaks.

I can't seem to find which character to use for the line
breaks.
 
J

John Spencer (MVP)

Two characters are required and in order.

"XXX" & Chr(13) & Chr(10) & "YYY"
returns

XXX
YYY
 
G

Guest

Many thanks to John for the following.
Grimble
-----Original Message-----
Two characters are required and in order.

"XXX" & Chr$(13) & Chr$(10) & "YYY"
returns

XXX
YYY


.
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

Time Calculated minus breaks & lunch 2
Excel Concatenate with line breaks but ignore blank cells 3
Text and Memo field concatenation - Line break (Access 2007) 4
Rich Text Format 0
Writing Queries with Line Breaks 2
how to break apart a large table field into smaller ones in SQL 3
adding a Carriage Return or Line Feed character to an update query 2
stripping html 6

Top