Social Security / Tax ID Field

  • Thread starter Thread starter L.A. Lawyer
  • Start date Start date
L

L.A. Lawyer

I want to set up a single field for social security numbers (###-##-####) as
well as corporate tax ID numbers (##-#######). Does anyone have the
settings to do this?
 
Its a 9 character text field, but the presentation will be the challenging
part, given the quantity and spacing of the dashes. Not too sure how you
can do this in one field. Can you do a second field to indicate what type
of ID it is, like S for SSN and T for tax ID?
 
On further review, you could make it a 10 character text field with the
first (or last) character being an S or T, then conditionally format in
forms and reports, based on whatever that character is. This would meet
your one field requirement.

--
Kevin3NF

Sick of all that junk filling up your mailbox?
http://spamarrest.com/affl?2967001
 
Back
Top