The command Instr (string1$, string2$, offset) searches for the occurrance of String2 into String1 and then returns the offset of the string found. Since it returns 0 only if it doesn't find the occurrance, this function also tells if the string has been found or not.
EDIT: Oh, but you're not talking about blitz products it seems... anyway, the instr command works similarly in access too.
It looks like Instr(StartOffset, string1, string2, CompareConstant [vbTextCompare in this case])
EDIT: Oh, but you're not talking about blitz products it seems... anyway, the instr command works similarly in access too.
It looks like Instr(StartOffset, string1, string2, CompareConstant [vbTextCompare in this case])