exact field

[Robbydobbs]

Is there a way to setup a field so that whenever data is put into the field and you have to do a search on this field that it is already setup to be (==)exact and nothing else but that number will come up?

example:

If the field is "customer #" and the number is "10" and I do a search on this field I only want the "10" to come up and not 101, 1001, 100 and so on.

[CobaltSky]

Hi,

If your Customer# field is defined as a text field, then a search for 10 will find 10, 100, 101 etc.

However if it is defined as a number field, a search for 10 will only find 10.

[Ugo DI LUCA]

keep a calc field TextToNum for any serial "text-number" field in your db, and search this field instead.

[Robbydobbs]

Thanks that works great.