Splitting up a string

[Zaeed]

If i have a string such as bob, allen, tim, frank etc, what code would i use to split that up into individual words, and put the words into an array.

I know you would basically navigate along the string and breaking at the ' , ' but im not sure how to do it in VBA

Cheers

 

[WayneRyan]

Zaaed,

Believe it or not, it's the SPLIT function.

Do a search here for examples.

Wayne

 

[keirnus]

hehehe...

i agree with WayneRyan...

do a little bit of search and
you'll know the syntax to use...
after that, use you're logic...

 

[dkinley]

Might want to take a look at InStr in the Access Help files.

-dK