line break

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i've got this expression in the query:

Sentence: [text] & [text] & [text]

which will display as: texttexttext

i'd like to insert a line break so that the second and third items in the
text string appear on separate lines within the field, like this:

text
text
text
 
i've got this expression in the query:

Sentence: [text] & [text] & [text]

which will display as: texttexttext

i'd like to insert a line break so that the second and third items in the
text string appear on separate lines within the field, like this:

text
text
text

In a query?

Sentence:[Text1] & chr(13) & chr(10) & [Text2] & chr(13) & chr(10) &
[Text3]
 
Back
Top