Column value's to text box

[skippypower]

hi,

im trying to convert all the values in a table/querie coulmn into coma seperated values in a text box. like:

table column:
a
b
c
d
e

*Some VBA Magic*

Textbox = a,b,c,d,e

Not realy sur where to start....any ideas? i presume some sort of loop is needed?

 

[John Big Booty]

Perhaps this is the sort of thing you are looking for?

 

[skippypower]

Thanks man, but your link doesn't seem to be working....

 

[Kiwiman]

Howzit

FYI - The link works fine for me.

 

[John Big Booty]

Howzit

FYI - The link works fine for me.

Works for me too

Try; http://access.mvps.org/access/modules/mdl0008.htm

 

[vbaInet]

Or this:
http://allenbrowne.com/func-concat.html