multi-line values possible in text columns?

I have a virtual text column called [Description], which is the concatenated value of three other columns, but I can't get it to display the way I'd like.

 

The desired output is:

"[column A]

[column B]

[column C]"

 

The result I keep getting is: "[column A] [column B] [column C]". Is it possible to get multi-line text output for a single column?

Solved Solved
0 2 207
1 ACCEPTED SOLUTION

Yes, you can do this in a LongText type column.  You will need to build the text with newlines inserted, like this:

[Column A] & "
" & [Column B] & "
" & [Column C]

The quotes are surrounding the newline,  with the second " on the next line. 

View solution in original post

2 REPLIES 2

Yes, you can do this in a LongText type column.  You will need to build the text with newlines inserted, like this:

[Column A] & "
" & [Column B] & "
" & [Column C]

The quotes are surrounding the newline,  with the second " on the next line. 

exactly what I needed. Thank you!

Top Labels in this Space