NoMatch Property

Object List Next Object

Defined By: Dynaset

Description:

Indicates whether or not a "Find" method was successful in locating a record that matched the criteria. The value for NoMatch is False when a Dynaset is first opened or created.

Settings:

---

Setting Description

---

True A Find method failed to locate a matching record.

False A Find method succeeded in locating a matching record.

Details:

After you use a Find method, which includes FindFirst, FindPrevs, FindNext, or FindLast, inspect the NoMatch property value to see whether the operation succeeded. If the operation does not succeed, meaning no match was found, the NoMatch property is set to True and the CurrentRecord object reference is cleared. If the operation succeeds, meaning a match is found, the NoMatch property value is False and the CurrentRecord is set to the found record.

---

Note: The NoMatch property is often used in Do Loops.

Data Type: Boolean

See Also:

BOF property;EOF property;FindFirst, FindLast, FindNext, FindPrev methods, Do...Loop statement