Finding Information with the Enhanced Data ControlFinding information in a database field is a snap with the Enhanced Data Control. To activate the Find dialog, click the
button. You can use the and buttons to continue searching once you've found a match. 
Find Specify the data to search for. A list of recent searches is available by clicking the button. Direction Specifies the direction in which to search. Selecting Down will search from the current point to the end of the database. Selecting Up will search from the current point to the start of the database. Less Than Match only if the text entered in the Find dialog is less than the value in the database. Examples of this are 1 < 2 and APPLE < BEAR Less Than or Equal To Match only if the text entered in the Find dialog is less than or equal the value in the database. Examples of this are 2 <= 2 and APPLE <= BEAR Equal To Match only if the text entered in the Find dialog equals the value in the database. Examples of this are 5 = 5 and DOG = DOG Greater Than or Equal Match only if the text entered in the Find dialog equals or exceeds the value in the database. Examples of this are 7 >= 2 and DOT >= DOS Greater Than Match only if the text entered in the Find dialog exceeds the value in the database. Examples of this are 10 > 9 and TREE > BARK. Partial Match Match only if a portion of the string specified in the Find dialog matches a portion in the database. An example of this is specifying "Eng" in the Find dialog and returning "Engine" and "England". This works for strings only. Soundex Match only if the string sounds like one in the database. An example of this is specifying "Skool" and returning "School". This works for strings only. Note: you can press the ESC key during an extensive search to exit. See Also: Database Tools Working with tables |