changing default search on a form

[zionman4]

Hello everyone,
When doing a search on data in an Access form, the dialog box comes up with the "match" drop down defaults to "whole field". Is there anyway to make this default to "any part of field" instead or "Start of the Field"?...

Thx!

 

[MarkSweetland]

Not directly through code. Here's a link to the MSDN article that shows how to change the defaults using SendKeys.

http://support.microsoft.com:80/support/kb/articles/q120/9/12.asp&NoWebContent=1

Mark

"You guys pair up in groups of three, then line up in a circle."
- Bill Peterson, a Florida State football coach

 

[zionman4]

That did id, thanks!!

 

[zionman4]

That did it, thanks!!

 

[zionman4]

FYI,
Here is the code for the above question according to the MSN article:

Based on a search for a field named "Last_Name":

DoCmd.GoToControl "Last_Name"
Screen.ActiveControl.SetFocus
SendKeys "%hs%n", False
RunCommand acCmdFind