ChipperT Banned in 13 Countries Local time Today, 06:53 Joined Jun 1, 2010 Messages 347 Oct 18, 2010 #21 If this is a web HTML report (and not PDF) use this: =[SchoolAddress1] & "<br />" & [SchoolAddress2] & "<br />" & [SchoolCity] &", "&[SchoolState] & [SchoolZipCode]
If this is a web HTML report (and not PDF) use this: =[SchoolAddress1] & "<br />" & [SchoolAddress2] & "<br />" & [SchoolCity] &", "&[SchoolState] & [SchoolZipCode]
boblarson Smeghead Local time Today, 06:53 Joined Jan 12, 2001 Messages 32,059 Oct 18, 2010 #22 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]
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]
L Learn2010 Registered User. Local time Today, 09:53 Joined Sep 15, 2010 Messages 415 Oct 18, 2010 #23 None of these worked.