Searching on Numerical Fields

Searching on Numerical Fields

When using the FindFirst method I seem to be able to locate only records which are defined as strings using a variable in the search pattern.

When I am searching for integer values I cannot find the correct syntax to pass the variable name at best I get a response of Type mismmatch when I pass it as a string.

If I replace the variable with a constant (eg 1 or 2) then no problems — the record is found.

All referances I have seen only refer to searching for strings

You can just say:

RecordSet.FindFirst “integerfield = ” & val(TextBox.Text)
This will do a find of ‘integerfield = 3’, for example.


Share the Post: