How to validate character length

B

Bruce Manley

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
 
S

Sue Mosher [MVP-Outlook]

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with MS Word paragraph and character styles: format getting messed up 2
Data validation, mandatory and restricted field length for excel vbs 10
How to create bulleted to-do list using two styles? 5
Query / Count Length Of Field 3
How do I install Microsoft Equation 3.0 back to Office 365? 0
retrieve last three characters of field 2
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Select A Character In A Part # 1

Top