Force a new line between concatenated fields in a text box

  • Thread starter Thread starter Cath
  • Start date Start date
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
 
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]
 
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.
 
Back
Top