Hi

Can any one please tell me how I can set the "match" criteria on find button to "Any part of Field" all the time using vb code, without me having to change it all the time

Help would be greatly appreciated
http://www.access-programmers.co.uk/forums/images/buttons/edit.gif (http://www.access-programmers.co.uk/forums/editpost.php?do=editpost&p=864617)

What version on Access are you using? If you're using '03 there is a setting in:
Tools -> Options -> Edit/Find Tab -> "Default Find/Replace Behavior"

This might be what you're looking for.