CTRL + F Mods

[hawkesms]

Hi

I have been asked if it's possible to modify or set parameters when using Find i.e. when you hit CTRL + F in Access 2003

The question is can I use VBA code to modify things like the "Match" to be 'Any Part of Field' instead of defaulting to 'Whole Field' etc?

Many thanks for your help!

 

[Keith Nichols]

Hi,

I had the same request a few months ago. Check out this thread.

http://www.access-programmers.co.uk/forums/showthread.php?t=108451&highlight=find

All my find searches, either from the find button or the control+F give the criteria set to 'any part of field' which suits my users.

Hope this helps.

 

[hawkesms]

Thank you very much!

Saved me a lot of grief

 

[Keith Nichols]

You're welcome Hawksesm.

Enjoy the forum.