Force a new line between concatenated fields in a text box

C

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
 
M

Marshall Barton

Cath said:
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
Click to expand...


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

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