H
hdfixitup
I have two text fields storing part numbers. One stores the stripped number
and the other stores the spaced number. Example: (12345 and 12 34 5). I
have an unbound Search text box that I currently type a stripped number into
and the record is retrieved.
DoCmd.GoToControl "[NumberID]"
DoCmd.FindRecord .Search, acEntire, False, , False, , True
DoCmd.GoToControl "Number"
I need help on the following:
If a spaced number is entered, I would like to strip all spaces and have it
find the stripped number as if I had typed the stripped number first. can
anyone help me? Thanks in advance.
hdfixitup
and the other stores the spaced number. Example: (12345 and 12 34 5). I
have an unbound Search text box that I currently type a stripped number into
and the record is retrieved.
DoCmd.GoToControl "[NumberID]"
DoCmd.FindRecord .Search, acEntire, False, , False, , True
DoCmd.GoToControl "Number"
I need help on the following:
If a spaced number is entered, I would like to strip all spaces and have it
find the stripped number as if I had typed the stripped number first. can
anyone help me? Thanks in advance.
hdfixitup