I'm struggling to concatenate the data where two or more lines are blank.
I have an unbound text box on my form with the following.
=[Address_Line_1]+Chr(13) & Chr(10)+[Address_Line_2]+Chr(13) & Chr(10)+[Address_Line_3]+Chr(13) & Chr(10)+[Address_Line_4]+Chr(13) & Chr(10)+[City_Town]+Chr(13) & Chr(10)+[County]+Chr(13) & Chr(10)+[Country]+Chr(13) & Chr(10)+[Postcode]
However if Address_Line_3 AND Address_Line_4 are both blank then I get the following result:
1 Any Street
AnyArea
Townsville
Countyshire
United Kingdom
123 ABC
as you can see there is a blank on line three.
This anomaly occurs when there are two or more consecutive blank address lines.
Can anybody suggest a solution?
I have an unbound text box on my form with the following.
=[Address_Line_1]+Chr(13) & Chr(10)+[Address_Line_2]+Chr(13) & Chr(10)+[Address_Line_3]+Chr(13) & Chr(10)+[Address_Line_4]+Chr(13) & Chr(10)+[City_Town]+Chr(13) & Chr(10)+[County]+Chr(13) & Chr(10)+[Country]+Chr(13) & Chr(10)+[Postcode]
However if Address_Line_3 AND Address_Line_4 are both blank then I get the following result:
1 Any Street
AnyArea
Townsville
Countyshire
United Kingdom
123 ABC
as you can see there is a blank on line three.
This anomaly occurs when there are two or more consecutive blank address lines.
Can anybody suggest a solution?