Insert line feed in a string

[Tom]

In my report the first column has company name, address, city-state-zip,
telephone, and web site.

The field is built by adding text strings with the "&".

How do I get the the report to insert a line feed after the company name,
adress, city-state-zip and, telephone?

 

[Rick Brandt]

In my report the first column has company name, address,
city-state-zip, telephone, and web site.

The field is built by adding text strings with the "&".

How do I get the the report to insert a line feed after the company
name, adress, city-state-zip and, telephone?

=[city] & Chr(13) & Chr(10) & [state] etc..

 

[Tom]

Ok, thanks. It works on text fields but not hyperlinks.

www.microsoft.com becomes

www.microsoft.com#www.microsoft.com#

In my report the first column has company name, address,
city-state-zip, telephone, and web site.

The field is built by adding text strings with the "&".

How do I get the the report to insert a line feed after the company
name, adress, city-state-zip and, telephone?

=[city] & Chr(13) & Chr(10) & [state] etc..