Hi
I have created an Access database with a navigation button on the form. When the Find and replace pop-box comes up, each time the LOOK IN box and the MATCH box defaults to the same place ie MATCH defaults to WHOLE FIELD and I want it to search ANY PART OF FIELD. Does anyone know if this can be altered to default to ANY PART OF FIELD.
Thanks for reading
gg