Many thanks for your prompt reply - I have now tried both of the options suggested by you - but they return errors of incorrect syntax or expression to complex to evaluate?
Smac
The expression
Like "*"&[find what]&"*"
works in 2003 but does not work in 2007.
I am looking for a similar expression which carries out the same function - a keyword search within field in table.
Cheers