Solved

Social Security numbers in Outlook 98  custom form

Posted on 2001-06-15
5
164 Views
Last Modified: 2010-04-08
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.
Thanks,
David
0
Comment
Question by:dpeel
  • 3
  • 2
5 Comments
 
LVL 9

Expert Comment

by:rjcpjc
ID: 6197195
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.  
0
 

Author Comment

by:dpeel
ID: 6202775
I'm ok with answer #2.

I need more bonehead type instructions for the first question.
Thanks
0
 
LVL 9

Expert Comment

by:rjcpjc
ID: 6202991
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.  





0
 

Author Comment

by:dpeel
ID: 6203190
I don't know jack about Visual Basic. Is there an alternative method built into the Outllok 98 program?
0
 
LVL 9

Accepted Solution

by:
rjcpjc earned 200 total points
ID: 6203224
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.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Find out how to use dynamic social media in email signatures with this top 10 DOs & DON’Ts.
Resolve DNS query failed errors for Exchange
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now