Force a new line between two concatenated fields on a report 1

[MrsNic]

I have concatenated two fields in a text box on a report I have created, both are memo fields. I want to force a paragraph break between the two paragraphs.

I have tried [paragraph1]&CrLf&[paragraph2] but this just automatically puts square brackets around the carriage return.

Any assistance gratefully received!

 

[MichaelRed]

ContrlSource:

=[paragraph1] & vbcrlf & vbcrlf & [parageaph2]

although you MAY have some difficulty in the total display, as the textbox (.value) size limitation may limit the display.






MichaelRed

 

[MrsNic]

Thank you for the suggestion but it just duplicated the error this time I achieved two sets of square brackets.
Cath

 

[dhookom]

You can't ever use constants like vbCrLf in a control source of a control. These constants are limited to code only.

You can use:

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

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[MrsNic]

Thanks, that worked.

Cath