C
Charles Strickland
I have a database that stores inventory numbers. The
inventory numbers have the format like 01-0001, 01-0002
and so on. The field which stores the inventory number has
an input mask like !99\-9999;;. When I search for
inventory numbers using the find what box I type 010001
(NOT 01-0001) in the box and I have NO problems finding
the inventory number. But now I have added a simple button
on the form using the tool wizard. The button navigates
you back to the 1st record on the form. Now when I type
010001 in the find what box it can not find the data! If I
type 01-0001 it finds the data. Sometimes it takes 2 or 3
instances of using the navigation button and searching to
recreate the problem. I need help and have no clue what is
happening. I want to use input mask but my users need to
use the find what box in a reliable manner. Thanks!
inventory numbers have the format like 01-0001, 01-0002
and so on. The field which stores the inventory number has
an input mask like !99\-9999;;. When I search for
inventory numbers using the find what box I type 010001
(NOT 01-0001) in the box and I have NO problems finding
the inventory number. But now I have added a simple button
on the form using the tool wizard. The button navigates
you back to the 1st record on the form. Now when I type
010001 in the find what box it can not find the data! If I
type 01-0001 it finds the data. Sometimes it takes 2 or 3
instances of using the navigation button and searching to
recreate the problem. I need help and have no clue what is
happening. I want to use input mask but my users need to
use the find what box in a reliable manner. Thanks!