If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Change default "Find" settings
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. |
#2
|
|||
|
|||
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 procedu 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. -- Good Luck! Graham Mandeno [Access MVP] Auckland, New Zealand "Mary M" wrote in message ... 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. |
#3
|
|||
|
|||
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. -- Good luck Jeff Boyce Access MVP "Mary M" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
change the default display settings for phone numbers so they have | DKay | Contacts | 1 | March 14th, 2005 09:40 PM |
How to change documents back to their default settings? | change document to its default setting | Formatting Long Documents | 1 | December 6th, 2004 12:59 PM |
OL2003: OPS + CIW not capturing/providing all required settings for default profiles | Steven Bendis | Installation & Setup | 1 | June 8th, 2004 07:51 PM |