Change default "Find" settings

[Mary M]

Is there a way to change the default Find settings from Whole Field to Any
Part of the Field? The user has to keep switching it.

Many thanks in advance.

 

[Graham Mandeno]

Hi Mary

I don't know of any way to do so, but if your users are constantly using the
built-in Find window then you should make it easier for them.

Are they always doing the Find in the same field? If so, add an unbound
textbox to your form, with the following AfterUpodate event procedure:

Private Sub txtFind_AfterUpdate()
If Len(txtFind) > 0 Then
Me.Filter = "[FieldToSearchIn] Like ""*" & txtFind & "*"""
Me.FilterOn = True
Else
Me.FilterOn = False
End If
End Sub

Then, all the users need do is type something into the textbox (or clear it
to show all the records).

If you want them to select a field to search in, add a combo box with the
possible fieldnames, and insert the selected field name in the appropriate
place in your filter string.

 

[Jeff Boyce]

Mary

You posted in the "tablesdbdesign" newsgroup, so I'll assume you are trying
to change the default Find setting for a table (for your user).

Access tables store data, and Access forms display it. If your user is
working directly in the table, you (and your user) are missing some of the
strong features that the form event model offers (and exposing your data to
greater risk).

That said, take a look at the Tools menu, Options -- one of the tabs offers
a way to change the default Find method.