Text delimiters in Reports

[Katy]

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

 

[llkhoutx]

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.

 

[Katy]

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?

 

[llkhoutx]

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