Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Field Validation
Message
 
 
To
04/08/2005 20:54:53
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01038791
Message ID:
01038796
Views:
20
>I want to make sure some enters at least 9 characters in the SSnumber field. What do I put in the firld valadatiuon rule?
>
>I have the following set format set to 999999999 and input mask set to 999-99-9999.

Clear Format property. It controls behavior of whole textbox not position by position. For example, one '!' there means that all characters entered in the textbox will be converted to uppercase. Put 'R' there so none-formating characters specified in the InputMask will not be saved. for example '123-45-6789' will be saved as '123456789'. Put following code into Valid of the textbox
IF LEN(ALLTRIM(This.Value)) <> 9
  RETURN .F.
ENDIF
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform