Here's the answer
For anyone that's interested, I found the answer myself. Go to Tools menu, click options. Then click Edit/Find. Then under Default find/replace behavior, chose General Search to search all fields and match any part of the field. NOTE: Changes made to this setting don't take effect until the next time you start Access.