How do I print a value list in a straight line?

[The Digital Man]

O.K. I have a value list made up of single letters.

 

A

P

C

S

 

Lets say the above letters are my value list. Now I have presented the value list as a checkbox on the screen. Lets say the user checks A, C, & S. I want to print these letters in a report as: "ACS". But the values go into my storage field as:

 

A

C

S

 

How do I strip the returns out? Or are there some preferences I am not implementing?

 

Thanks for any help on this issue. I guess my question is what is the best and fastest way for me to get the letters into a text string format for printing in my report.

[Robert Schaub]

Set Field [YourField] [substitute(YourField,"¶"," ")]

[Ender]

This may be obvious, but if you want to keep the original field intact, then use the substitute() function above in a new calc field instead of using a script.

[The Digital Man]

Thank you guys.

 

Am I understanding Ender right. Once I strip the returns out of the field than the field won't display correctly on my first entry screen with the checkboxes?

 

I am assuming this to be correct. So I will use a seperate field.

[-Queue-]

Correct. The carriage returns (¶) are what cause multiple checkbox items to display correctly. Substituting spaces for them into your original field will cause all items to appear on the same line and none of the items will appear to be checked.