Dictionary lookup

[Dazza666]

Hi,
I have a lookup table which stores key words that we need to be aware of if they are entered in to the database.

What I need to happen is if a word is typed in to a certain textbox or memo field that word is flagged if it appears in the lookup table, I thought about a dlookup statement in the onupdate event of the memo field but I can't figure out how to detect individual words within the string of text?

Any help would be greatly appreciated

thanks!

 

[gemma-the-husky]

this is a lot of work

the easiest way (you need Access 2000 or later) is to use split function, which will separate your text string into an array of words (using space as the separator)

then for each word in the array, test against your dictionary

either use textbox beforeupdate event, or textbox after update event, depending on what you want to do with the info

 

[Dazza666]

this is a lot of work

the easiest way (you need Access 2000 or later) is to use split function, which will separate your text string into an array of words (using space as the separator)

then for each word in the array, test against your dictionary

either use textbox beforeupdate event, or textbox after update event, depending on what you want to do with the info

great I'll research the split function and give it a shot

thanks