extract text from comma seperated values in a text box

hi guys, girls

i have users entering words in a text box seperated by commas. i need to use those words as values in a search. there might be only one word, but then there might be twenty or only three. i need my code to extract the words there and then to build a sql statement that is going to be used to search the relevant area of the table for matching values. i am using access 2003.