DataFind Matching Page

All Records in recordset

(MatchType property)

If selected, DataFind moves to the next record on each entry. The data matching fields are not used.

Records where this field

(MatchField, MatchData properties)

If selected, DataFind searches the database for the next record that matches the specified data. The text you enter may contain control names. If using a Jet database, enter the fields manually because the control cannot determine which database will be used at runtime. When using bound data controls or ODBC databases, a drop-down list of fields is provided.

Matches this data

Click the %% button to open Available Controls dialog. Select desired control name and/or property.

Match characters exactly

Performs a normal comparison, character by character, between the database contents and the data in the For... field.

Match using digit translation

(AlphaMatch property)

Translates the text in the database field to the telephone keypad equivalent before performing the comparison. This is useful for directory lookup, for example, where the caller is limited to using telephone keys to represent an alphanumeric name.

NOTE: Different telephony keypads assign letters Q and Z to different keys. In VBVoice, both letters are assigned to digit 1 by default, but this may be overwritten by settings in the System section of the VBVoice.ini configuration file. For example, to reassign both letters to digit 0, use the following settings:

[System]

DialPadMapping_Q = 0

DialPadMapping_Z = 0

Match first characters

This search algorithm matches the Records containing text field against the database contents. It stops matching and reports a successful match if it reaches the end of the Records containing text field without a mismatch. See searching for data.

All characters must match

Matches the entire text field against the database contents. In this scenario the database field and the contents of the selected field must be identical.

Note: If doing a match on characters exactly or match on all characters, it is more efficient to set up your recordset to include only the records you want by using a WHERE statement or using a Filter (not available if using a bound data control).

Read more about DataFind control.