Social Security numbers in Outlook 98 custom form

I have run into a road block in setting up this field.

What I want is the typical format 000-00-0000 which the form accepts w/no errors. It won't however save the information.

It would be ideal if the slashs stayed in place and after entering 3 digits jump to the area holding the next two digits and jump to the last four.

Another slight annoyance is the date of birth field after being enter as 01/01/2001 it displays as January,01, 2001.

Appreciate any assistance.
Who is Participating?
rjcpjcConnect With a Mentor Commented:
Actually its VBScript.  Sorry for the confusion.  But that's about the best alternative.  Other than just using three fields, one for the first three numbers, one for the second two numbers and one for the last four numbers.
1.  A couple of options.  a)Set up three separate fields.  
b)Use the instr and len functions to test the field to make sure that you have three digits then two then four with dashes in between.

2.  You should be able to go into properties of the field and go to Format and change the date field's format to 01/01/2001.  
dpeelAuthor Commented:
I'm ok with answer #2.

I need more bonehead type instructions for the first question.
Here is some sample code for b:

tmpSSN = Item.UserProperties.Find("ssn").Value
SSNLength = Len(tmpSSN)

If SSNLength <> 11 then
  msgbox "Your SSN does not have enough characters.  Please reenter"
End If

'Test for a dash in the first four characters

tmpSSN1 = Left(tmpSSN,4)
fdp = Instr(tmpSSN1,"-")

If fdp <> 4 then
   msgbox "You must have a dash (-) as the fourth character"
End If

'Takes the next three characters from the string

tmpSSN2 = Mid(tmpSSN,5,3)  

fdp2 = Instr(tmpSSN2,"-")
If fdp2 <> 3 then
  msgbox "You must have a dash as the 7th character"
End If


Hope this helps a little.  Get the Visual Basic Help Files from Microsoft's site.  They are very helpful.  

dpeelAuthor Commented:
I don't know jack about Visual Basic. Is there an alternative method built into the Outllok 98 program?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.