2. ASPRunnerPro General questions
  3. Checkbox lists when selecting multiple boxes
This topic is locked

Checkbox lists when selecting multiple boxes

 		2/5/2010 4:33:16 PM
ASPRunnerPro General questions
C
 codywallace author

ASPRP,
I have another question regarding "checkbox lists". I've discovered this to be a nice feature because there are occasions when being able to select multiple choices can be useful. One thing about the feature I can't make work in a way that makes the recorded data presentable is how the multiple selected items have the appearance of being slammed together.
What I mean by this is that there is no space after the comma "," that is used to separate each selected choice.
For example, if the user selects three choices such as Apple, Orange, and Peach, the data that is recorded into the database is entered without any space " " after the commas.
This is what it looks like currently: Apple,Orange,Peach

This is how I would like it to look: Apple, Orange, Peach
Is there any way to add a space after each comma that is inserted between each selection?
Thanks again.
admin 2/5/2010

I'd try to set 'View as' of this field to 'Custom' and use the following code:
value = Replace(value, ",", ", ")
S
 		surfermac 3/21/2010

How can I save it to the DB as: Apple | Orange | Peach ?
Basically replace , with |
admin 3/21/2010

value = Replace(value, ",", "|")
S
 		surfermac 3/22/2010

Where do i put the code.? I tried to put it in "View As" - "Custom" and is still putting the comma in. I would like to use | as my separator.
Thanks
J
 		Jane 3/24/2010

Hi,
try to use this code on the "View as" settings --> Customon the Visual**Editortab:

strValue = Replace(strValue, ",", "|")**