Home About us Development Training Support |
Search options in Microsoft AccessUse the button (or the shortcut) to find data in a table or in a form. This dialog will appear to let you choose what to search for and how to search for it.
Find What:Enter the text or numbers you're searching for here. Search:This setting determines how much of the table will be covered by the search.
Match:This setting determines how much of the field is going to be searched.
Match CaseTick this if you want Access to take account of the case of the letters you're looking for. It's best to leave this clear unless you are absolutely sure that the data has been entered in the correct case. Addresses in particular can be a mixture of 'UPPER', 'lower', and 'Proper Case' entries. Search Fields As FormattedThis box is greyed unless you have ticked It becomes important when you have a field that is being displayed in a special format. For example, a search for '40' will find a price of '#40' if this box is clear. You would have to search for '#40' if the box were to be ticked.Search Only Current FieldThe search will be faster if you tick this box because Access will be able to concentrate on single field and may be able to use an index rather than having to use brute force techniques to examine every field. Presetting the optionsIf you select on the menu and select the page then you can set the default type of search.
Note that the option you choose won't take effect until the next time that you start Access. |
Hints & tips
The textbox class in Visual FoxPro 9 has a new Autocomplete
property which shows the user the previous values that have
been entered in that textbox.
More...
|