Hi,

I'm trying to find a function that will return a boolean value showing whether a specific letter appears in a word.

I have a list of thousands of words, and I've created a parameter query asking what letter is being searched for. I want to return all words in the list that contain that letter, but can't see how. I've been looking at InStr, but that's not it.

TIA for any help,
J.

InStr() IS what you are looking for. It will return a number (the position of the letter in the string) or 0 if the letter is not in the string, so use this as your Boolean:

If result = 0 = False
If result <> 0 = True

Did that work?

mmcdonal

Aha - thanks a lot, mmcdonal, it's working fine now! I was using it wrong, putting in criteria that messed it up.

Cheers,
J.