line breaks

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

 

[Guest]

Will chr(13) work?

 

[Newbie]

vbCrlf

HTH

 

[John Spencer (MVP)]

Two characters are required and in order.

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

XXX
YYY

 

[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


.