Good Morning,
Have Database Fields; Address1, Address2, Address3, Address4.
Designed a Report with One Text Box linked as;
=[Address1] & "," & " " & [Address2] & "," & " " & [Address3] & "," & " " & [Address4]
Now wanted 2 requirements;
1. If [AddressX] is blank, char "," should not print, which is printing with the above code.
2. How print "On the next line after printing [Address1] and [Address2]" ?
Thanks in Advance.