social security numbers again

[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

[Larry Linson]

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