key word search

[shaggyjb]

Does anyone have an idea how i could search for a keyword in a field. The field is a Thesis title and could be a sentence or two long. I just need to return any Thesis' containing the given keyword.

thanks

 

[raskew]

'Piece of cake'--use the InStr() function.

Try these from the debug window:
*************************************************
Field1 = "The quick brown fox jumped over the lazy dog now is the time for all good men"
Field2 = "Give me liberty or give me death Four-score and seven years ago ask not what your country"
? iif(instr(field1, "four-score and seven years ago")>0, True, False)
False
? iif(instr(field2, "four-score and seven years ago")>0, True, False)
True
? iif(instr(field1, "or give me")>0, True, False)
False
? iif(instr(field2, "or give me")>0, True, False)
True
*************************************************
Then lookup the InStr() function in the help file.