Concatenation: Insert New Line

[Peter Cox]

I would be grateful for your assistance. I want to output a number of fields which hold address data in one box on a form so that I can copy the whole address to paste elsewhere.

I can concatenate the fields but do not know, nor cannot find how to force a new line after each field so that the result will look like:

2 Mangy Cat Road
Stroppington-on-Sea
Stroppshire
ST12 9DR

as opposed to

2 Mangy Cat Road, Stroppington-on-Sea, Stroppshire, ST12 9DR

There is a work-around, outputting the address into Word, but I would prefer to find the more elegant solution.

Regards

Peter

 

[boblarson]

In VBA it would be:

Me.Yourfield & vbCrLf & Me.YourOtherField

in a query it would be

NewFieldName:[YourField] & Chr(13) & Chr(10) & [YourOtherField]

 

[Peter Cox]

Bob,

Many, many thanks.

Peter

 

[shae marks]

I would be grateful for your assistance. I want to output a number of fields which hold address data in one box on a form so that I can copy the whole address to paste elsewhere.

I can concatenate the fields but do not know, nor cannot find how to force a new line after each field so that the result will look like:

2 Mangy Cat Road
Stroppington-on-Sea
Stroppshire
ST12 9DR

as opposed to

2 Mangy Cat Road, Stroppington-on-Sea, Stroppshire, ST12 9DR

There is a work-around, outputting the address into Word, but I would prefer to find the more elegant solution.