I have a field set as a checkbox list (5 rows high in the layout display).  On another layout, I want to use only the chosen options from the checkbox list, but I want to display them in a single line separated by a comma and a space (I'm pushed for space in the new layout).  The field will be displayed as an edit box in the new layout.

 

So, assume the list below from original layout containing checkbox:

A

B

C

D

E

 

Options A, B and E are chosen.  In the new layout, I require:

A, B, E

 

Any help much appreciated.

 

John

 

say that the field that  holds the values is named "selections"

 

then this would do it:

substitute( selections ; "¶" ; ", " )

 

if this is only useful for showing on the layout I would not sacrifice a calculated field for it but set it in a layout variable.

Thanks Wim. Got it working thanks to your advice.