Concat with Line Feed ?

[b_garside]

Hi I need to use Concat to show the values of a field using GetFieldSelections().

Im sure its a syntax issue with Chr(10). I need the values to go to the next line due to space constraints.

Concat(GetFieldSelections(ContractNumber),Chr(10) )

[Gysbert_Wassenaar]

Try Concat(ContractNumber,Chr(10))

[#3 · Accepted solution]

Try using a line break as shown, but with ContractNumber instead of Date:

[b_garside]

This works but list all the values rather just the few.

[Gysbert_Wassenaar]

It will list all the possible values of the field. Those would be the same values that getfieldselections would return if any values were selected in that field.

[#6]

You would need a DISTINCT.  Concat(DISTINCT ContractNumber,Chr(10))

[Gysbert_Wassenaar]

Ah, of course. Good point.

[b_garside]

This seemed to do the trick. Nice workaround.