Force a new line between concatenated fields in a text box

[Cath]

I am trying to set up a report which can have two
paragraphs but may only have one! I thought I would use
a concatenation but I cannot get it to automatically
force a new line for the new paragraph.

I used
=[paragraph1]&CrLf&[Paragraph2] this doesn't work any
suggestions please!

Cath

 

[Douglas J. Steele]

Try vbCrLf (or, if you're doing this in a query, Chr(13) & Chr(10))

 

[Marshall Barton]

I am trying to set up a report which can have two
paragraphs but may only have one! I thought I would use
a concatenation but I cannot get it to automatically
force a new line for the new paragraph.

I used
=[paragraph1]&CrLf&[Paragraph2] this doesn't work

=[paragraph1] & Chr(13) & Chr(10) & [Paragraph2]

 

[PC Datasheet]

Use two textboxes one above the other. Set the Can Grow and Can Shrink
properties of both to Yes. Put the first paragraph in the top textbox and
the second paragraph in the bottom textbox.