Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Social Security Number
- Thread starter JIL
- Start date
Jil,
Use the functions 'Position' and 'TextToNum' in the Validation for your field.
Use Position to make sure the hyphens are in the correct places. Use TextToNum to ensure the other stuff is numeric.
Very very roughly -
( Position(..first hyphen....) = 3) and (Position (...second hyphen...) = 7) and .......
and ( Len(TextToNum(SocSec) = Len(SocSec) - [number of hyphens])
(I can't be specific because I don't know the format of your Social Security number.)
Have a look at the help on both of these functions; they are a bit too long to repeat here.
Have fun.
Paul Cheers,
Paul J.
Use the functions 'Position' and 'TextToNum' in the Validation for your field.
Use Position to make sure the hyphens are in the correct places. Use TextToNum to ensure the other stuff is numeric.
Very very roughly -
( Position(..first hyphen....) = 3) and (Position (...second hyphen...) = 7) and .......
and ( Len(TextToNum(SocSec) = Len(SocSec) - [number of hyphens])
(I can't be specific because I don't know the format of your Social Security number.)
Have a look at the help on both of these functions; they are a bit too long to repeat here.
Have fun.
Paul Cheers,
Paul J.
- Status
Similar threads
- Locked
- Question