instead change the list box record source to value / field list
in the forms on load event populate the list box row source with the columnns from a recordset, seperating each columnn with a semi-colon. add the same numbers of semi colons as columns from the recordset
BUT, and its a big but, why do it?. You are creating more work for yourself, making yuou application less obvious to users used to WIMP programs
you have to trap for null values from the list box.
It can be doen, but I wouldn't think its a good idea unless you have a very good reason to do it.
Just thinking out aloud I wonder what would happen if you added either vbcrlf or chr$(10) to the end of a column if that would give the same effect?