Report Design - Text Box with Paragraphs

[sren]

Hi....I have encountered a couple of questions that seem to have left me puzzled even though I was not expecting it to be difficult.



I am working on a report that will print a letter. I want my text box to be formatted like a paragraph. When setting up an email to send and going through code builder, I have previously used the chr(10) and chr(13) (is what I think they were) to do indents and carriage returns. I can not seem to get any of this to work inside the text box. This is what I currently have (although I have had this about 10 different ways trying to get it to work):

=IIf([Region]="EU",[txt_C_EU_MainLetter],[txt_C_nonEU_MainLetter]) & " We appreciate your support and wish you every success for " & [ctlNextYr] & "."

I want it to look like this when printed:

Text from [txt_C_EU_MainLetter] or [txt_C_nonEU_MainLetter]
<blank line>
We appreciate your support and wish you every success for xxxx.

Any suggestions? I would like to be able to do everything inside one text box.

Thanks so much,
sren

[June7]

This works for me.
=IIf([Region]="EU",[txt_C_EU_MainLetter],[txt_C_nonEU_MainLetter]) & Chr(13) & Chr(10) & Chr(13) & Chr(10) & "We appreciate your support and wish you every success for " & [ctlNextYr] & "."

[sren]

This does not seem to be working. Everything works fine until the Chr(13), then it seems to ignore the remainder of the statement. Any additional thoughts or suggestions? Thanks.

[June7]

I can't replicate the issue so if you want to provide db for analysis, follow instructions at bottom of my post.

[sren]

Thank you. I will keep working on it; it will be extensive to create the db without the confidential data....basically, nothing will work. I appreciate your time.

[June7]

Test the expression without the fields, just with literal text. Will the cr lf code work then?

[sren]

I finally figured it out....I was missing the "$". I had "Chr(13)" instead of "Chr$(13)" etc. It works great now. Kindest regards!

[June7]

Any idea why the $ needed?

[sren]

No. I did not realize it could be required. I kept searching online for any tips and articles and finally came across one that indicated in some situations, the "$" may be required. (I am now understanding that this used to be a factor but should no longer figure in any longer.) Regardless, it now works (from what I can tell). Thanks for the feedback and assistance.