![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
![]()
I have a field for Social Security Number and I want to verify the character
length =9 characters. Or in other words I do not want the dashes entered in like 111-11-1111. What is the formula for character length? Thanks, Bruce |
#2
|
|||
|
|||
![]()
You can use the Len() function in your validation formula.
-- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Bruce Manley" Bruce wrote in message ... I have a field for Social Security Number and I want to verify the character length =9 characters. Or in other words I do not want the dashes entered in like 111-11-1111. What is the formula for character length? Thanks, Bruce |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
line length settings don't work | chance | Outlook Express | 1 | April 7th 06 03:14 PM |
How to validate a Custom Property Page | Jack Zhang | Add-ins for Outlook | 1 | February 9th 06 07:22 PM |
need to limit length of form in OL2003 | simon_ | Outlook - Using Forms | 3 | January 24th 06 04:30 PM |
Make outlook validate addresses against the GAL first before perso | Ravi Sabharanjak | Outlook - Installation | 1 | January 19th 06 12:40 AM |
How can I increase the mail body length when using mailto? | maxrael | Outlook and VBA | 3 | January 13th 06 10:17 PM |