Hi

I am using a data source which is downloaded from a 3rd party website. The address format has the whole address as one string and each address line is separated by a "/n". I would like to use the delimiters to start a new line within the text box of a report so the address looks correct when printed. Any ideas? It's the text to columns function in Excel but I can't seem to find the Access equivalent.

Thanks
Katy

Concantenate each "line" of the address with chr(34). e.g.

Relevant field recordsource is
=[name] & chr(34) & [address] & chr(34) & [city] & ", " & [state] & " " & [zipcode]

You'll get multiple lines.

Hi

Thanks for that. It's really useful in another part of the report but I'm not sure how to use it in this case.

The current address field [CustomerAddress] looks like this:

41 Highfield Roadn/Londonn/NW10 6QR

And I need it to look like:

41 Highfield Road
London
NW10 6QR

Would I use this function still?

Modify your funtion which is generating the address to concantenate a "CHR(34)" (or an vbCRLF) instead of a "/".