I have on field called “Body” and i want to search for the word “computer” in that field only.At present i am using Instr() function but it is not working properly,it is taking word partly but i want to take it as whole word.
Subject: How to search a word from a field
If You don’t need the exact position of the word then You could use the function Split(). This will return an array that You can loop through to search for the word “computer” - and even count how many times it occurs in the text.
If You absolutely need the position - then use Instr().
hth
Subject: How to search a word from a field
Amy,Using Instr(), you can get the position of the string you want to retrieve. Use this as start point. And you know the length of the string to be found, use that as length in Mid function.
Syntax :
Mid[$] ( expr , start [ , length ] )
This will extract the string you want.
Darshana