Thanks Seth
Works well. very grateful.
Mike
Shute112
Last Activity: Jul 26 '15, 07:04 PM
Joined: May 20 '15
Location:
-
Hi Seth
I have tried your Chr(10) but cannot get it to work. Can you please look at the string and see where I should be adding the Chr(10) and if possible could you type it out and I will copy straight into my query.
Addr: (+[HouseName]+",") & " " & (+[Address]+", ") & (+[Area]+", ") & (+[Town] & ", ") & [County] & ", " & [Postcode]...Leave a comment:
-
Hi ZMBD
Thanks for coming back to me so quickly. The table consists of separate fields for the name address etc. I have jointed the fields together into one string.
Addr: (+[HouseName]+",") & " " & (+[Address]+", ") & (+[Area]+", ") & (+[Town] & ", ") & [County] & ", " & [Postcode]
but would like to see the address...Leave a comment:
-
Multiline address block in ms access 2013 using a query
I have a table with address field and want to have a multi line address block on a form and report. What is the code in a string for line return. Example
First name surname
Address 1
Addess2
Town
County
Post code
No activity results to display
Leave a comment: