I have a formula that places the mailing address on a report as follows:
LeadingCaps({address1})
What I want is to check the value of address 2 and, if data is there, to print addr1, insert a line break, and then print addr2. I would ASSUME that the formula would look something like this (I know this doesn't work):
If {address2}="" then
LeadingCaps({address1})
else
LeadingCaps({address1}) + linebreak + LeadingCaps({address2})
The question is what function will insert the line break?
LeadingCaps({address1})
What I want is to check the value of address 2 and, if data is there, to print addr1, insert a line break, and then print addr2. I would ASSUME that the formula would look something like this (I know this doesn't work):
If {address2}="" then
LeadingCaps({address1})
else
LeadingCaps({address1}) + linebreak + LeadingCaps({address2})
The question is what function will insert the line break?