Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sanity check
Message
From
20/01/2005 11:51:36
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
00978922
Message ID:
00978934
Views:
17
This message has been marked as the solution to the initial question of the thread.
Hi Nadya

I'd imagine you'd put a .MaxLength of 9 on the field props and, in its .Valid(), check for LEN( lcSSN) = 9.

Don't think it's a good idea to check validity of SSN (i.e. as in see if it's valid format and/or "on file") until they've committed the typing, i.e. hitting the FIND button. It would annoy me if I made a typo (which DOES happen all the time), and was about to correct it, but the damn system tells me off. "I KNOW! GIVE ME A CHANCE!"

Terry

>Hi everybody,
>
>Just want to check, that there is no Input Mask/Format method to make sure, that all 9 (for SSN) characters are filled by the user?
>
>And also related question: for my search form I would allow to search by social security. What do you think would be a good place to perform a check wheither all 9 chars were entered: on the control lostfocus or on the hitting Find button?
>
>Thanks a lot in advance.
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Previous
Reply
Map
View

Click here to load this message in the networking platform