 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General MS InfoPath Questions / March 2008At least 10 numbers
I'd like to know how to make a rule that says that the user needs to put in at least 10 numbers (like the number of digits in a US phone number). Does this require an expression and if so, what are the steps and details needs to get the expression setup up? Thank you. In data validation or with rules add a condition and there is a comparison option for "matches pattern" in the dropdown. Then you can pick from one of the included patterns or create your own. Phone number is there but you can create your own custom pattern.  SignatureClay Fox / Microsoft InfoPath MVP www.InfoPathDev.com / The InfoPath Authority / Downloads, Samples, How-To, Experts, Forum > I'd like to know how to make a rule that says that the user needs to put in > at least 10 numbers (like the number of digits in a US phone number). Does > this require an expression and if so, what are the steps and details needs to > get the expression setup up? > > Thank you. If you use a Data Validation approach with the 'matches pattern' option, that is restricting the person to enter the numbers in a particular way (which I've tried already). Without asking the user to enter the numbers in a particular way, could it be done another way? > In data validation or with rules add a condition and there is a comparison > option for "matches pattern" in the dropdown. [quoted text clipped - 7 lines] > > > > Thank you. You would just add a rule to the field that after input or change to the field it would check the condition and if it did not match the pattern could either format it for the user using a sub string or pop a message or whatever you wanted. SignatureClay Fox / Microsoft InfoPath MVP www.InfoPathDev.com / The InfoPath Authority / Downloads, Samples, How-To, Experts, Forum > If you use a Data Validation approach with the 'matches pattern' option, that > is restricting the person to enter the numbers in a particular way (which [quoted text clipped - 14 lines] > > > > > > Thank you.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.