Concatenation: add a newline?

[kbrooks]

I want to combine 3 different fields into 1, with a newline inserted after each field. I know how to put them all together with &", " to make one big string. Is there a way to insert a newline between them?

I want them to appear like this:

Operation1
Operation2
Operation3



Or maybe a different answer to the same problem: I originally had the 3 fields listed on the report like I wanted them to appear, under one heading. This would work perfect if I could change the Can Shrink property to Yes since many records only have the Operation1 field filled in, and would save a lot of space on the report. But, they are combo boxes and that Can Shrink property is missing. Is there a way around that?

 

[Rich]

& Chr(13) & Chr(10) &

 

[kbrooks]

Thanks for your help. I made the following new field:

Operations: [Operation1Performed] & Chr(13) & [Operation2Performed] & Chr(10) & [Operation3Performed]

But what I get is one big long field with a box symbol where I'd like the line break to me. Did I type something in wrong?

Thanks again.

 

[Rich]

[Operation1Performed] & Chr(13) & Chr(10) & [Operation2Performed]

 

[kbrooks]

A true genius you are. Thank you very much, works like a charm!