See Also Example
Applies To
Table object, Dynaset object, Snapshot object.
Description
Indicates whether the FindFirst, FindPrevious, FindNext, FindLast, or Seek method was successful in finding a record. Not available at design time; read-only at run time.
Syntax
recordset.NoMatch
Setting
The NoMatch property settings are:
Setting Description
True A Find method or the Seek method failed (the desired record wasn't found).
False A Find method or the Seek method was successful (the desired record was found).
Remarks
When you first open or create a recordset or data control, NoMatch is False.
With the Recordset property of a data control, use one of the Find methods to make a specific record current. In the Professional Edition only, you can also use any of the Find methods with a Dynaset or Snapshot object, or the Seek method with a Table object.
After using a Find method or the Seek method, inspect the NoMatch property to see whether the record was found. If the operation fails (no matching record is found), the NoMatch property setting is True and the current record is undetermined. If a matching record is found, NoMatch is False.
Data Type
Integer (Boolean)