New Line In Field

If this is a web HTML report (and not PDF) use this:

=[SchoolAddress1] & "<br />" & [SchoolAddress2] & "<br />" & [SchoolCity] &", "&[SchoolState] & [SchoolZipCode]
 
Don't know if this will help but for a WEB FORM you may have to use HTML - so

Code:
=[SchoolAddress1] & [COLOR=red][B]<BR>[/B][/COLOR] & [SchoolAddress2] & [COLOR=red][B]<BR>[/B][/COLOR] & [SchoolCity] & ", " & [SchoolState] & " " & [SchoolZipCode]

or perhaps with quotes around them.

Code:
=[SchoolAddress1] & [COLOR=red]"<BR>"[/COLOR] & [SchoolAddress2] & [B][COLOR=red]"<BR>"[/COLOR][/B] & [SchoolCity] & ", " & [SchoolState] & " " & [SchoolZipCode]
 
None of these worked.
 

Users who are viewing this thread

Back
Top Bottom