Find Box

[aftershokk]

is there a way to auto uncheck the search field as formatted in Access 2003?

it speeds up searches ten fold when not checked and users asked for it to be auto turned off

thanks all!

 

[Beetle]

I don't believe there is any way to control the default behavior of the Search Fields As Formatted option in the Find and Replace dialog. The best you could probably do would be to roll your own search using a command button and the FindRecord method. the FindRecord method has a SearchAsFormatted property that you can control. Example;

Private Sub cmdSearch_Click()
 
Dim vFind As Variant
 
Screen.PreviousControl.SetFocus
 
vFind = InputBox("Find What?")
 
DoCmd.FindRecord vFind, acEntire, False, acSearchAll, [COLOR=red]False[/COLOR], acAll
 
End Sub

That second False controls the SearchAsFormatted property.

 

[aftershokk]

thanks but this actually makes the search slower, right now when the form is opened it opens directly to the name field and does a look in this field,
match whole field and searches all, when the box is unchecked it takes about 1 second to search 55k records, with it is checked or the suggested way it takes about 30-40 seconds or so....