How to validate character length

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You can use the Len() function in your validation formula.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Back
Top