using split function in access

[atksamy]

i am trying to get the values of a column in to an array

vari_able = Split(rs.Fields(astrFields(intIx)).Value, ",")

astrFields(intI x)). points to the field name.

but i am not getting all the values of the field i am gettin only one value
vari_able is declared as variant

[ADezii]

Are the values in the specific Column Delimited by a ','?

[atksamy]

no they are not i guess i made a mistake on that

[NeoPa]

What is the context of this code (the whole procedure it's in).

It looks like some of mine but done wrong. The elements appear in the wrong places in the code you've posted.

[NeoPa]

Ignore that last post - it's nonsense :(

The code is fine if you have data in a single field that should contain commas (,).

What you need to do is find out the actual contents of rs.Fields(astrF ields(intIx)) at runtime.