Convert list to string for text control

message from Dawn Pensiero on 08 May 2004
How can I create a text control the lists a recordset comma-delimited?
 
Albert D. Kallal replied to Dawn Pensiero on 8 May 2004
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....
 

Archived message: Convert list to string for text control (Microsoft Access Error Message)