Search Text Box for specific word - Find option

[bhashithe]

I'll explain what I need,
I have 5 textboxes and a multiline textbox in a form in my Access Database. I am going to type several keywords in those textboxes and I am going to type an article in the multiline textbox.

What I need to do is I want to calculate the keyword density in the article. I can do that if i know how to search the whole text in the article and count the specific word. And I want a function to count all the words in the article too.

If anyone can point me at the right direction It would be a great help!

Thanks in advance!!
Bhashithe

 

[Cronk]

I think I am typical of most of the professionals in this forum that we don't like multi line fields because we "default" to normalised tables.

Accordingly, you might not get response until you develop along those lines.