Convert list to string for text control

[Dawn Pensiero]

How can I create a text control the lists a recordset comma-delimited?

 

[Albert D. Kallal]

You can actually stuff a comma delimited list right into a listbox
control..nothing else is needed.


So, build a un-bound listbox..set the row source type to value list. Now, in
code go:


me.MyListBox.RowSouce = "one, two, three"

If you look on the screen, you will see nice box with


one
Two
Three

So, the nice listbox control by default accepts a comma delimited string....

I would not send too large of a string to that listbox...but the above does
work....