By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,828 Members | 1,862 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,828 IT Pros & Developers. It's quick & easy.

social security numbers again

P: n/a
Kif
Hello!

Thanks for the previous help! Now, I have found the SSN-mask, but I need
some help scripting it to controll the numbers. That you cant write month 13
for example or day 39 in a month, and I would also like to script that the
century needs to be 18th century (1900).

/Sincerely Kif
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
I'm sorry, but I don't understand what date values have to do with Social
Security Numbers.

You can't control these with the Input Mask, in any case, as they are
Validation rules -- you can specify some Validation rules in the Feld
properties in the Table itself, or in the properties of the Control on the
Form where the value is entered, or on the BeforeUpdate event of the
Control, or, finally, in the BeforeUpdate event of the Form.

By the way, depending on your point of view, 1900 was the last year of the
Nineteenth Century or the first year of the Twentieth Century. The 18th
century would be either 1700-1799 or 1701-1800, again depending on your
point of view. I will not argue which of these points of view is correct,
because I think it is a matter of opinion, and, as Rhett Butler said to
Scarlett O'Hara in _Gone with the Wind_, "Frankly, I don't give a damn."

Larry Linson
Microsoft Access

"Kif" <ki*@nospam.katedral.se> wrote in message
news:Y6********************@newsb.telia.net...
Hello!

Thanks for the previous help! Now, I have found the SSN-mask, but I need
some help scripting it to controll the numbers. That you cant write month 13 for example or day 39 in a month, and I would also like to script that the
century needs to be 18th century (1900).

/Sincerely Kif

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.