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

social security number

P: n/a
Kif
Hello!

Im looking for a macro that helps me to check out social security numbers
in a form. I want the macro to check that the written number got the full
length and so on. If you know how to script this or know where to find some
help, I would get very happy.

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


P: n/a
Can you use an InputMask on the control? Open the form in design view, click
on the control and then select InputMask from the properties dialog. I
believe there is a builtin SSN mask ...

--
Scott McDaniel
CS Computer Software
www.thedatabaseplace.net

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

Im looking for a macro that helps me to check out social security numbers
in a form. I want the macro to check that the written number got the full
length and so on. If you know how to script this or know where to find some help, I would get very happy.

/Sincerely Kif

Nov 12 '05 #2

P: n/a
"Kif" <ki*@nospam.katedral.se> wrote in message news:<o4********************@newsb.telia.net>...
Hello!

Im looking for a macro that helps me to check out social security numbers
in a form. I want the macro to check that the written number got the full
length and so on. If you know how to script this or know where to find some
help, I would get very happy.

/Sincerely Kif


you could always write some code in the OnExit event of the control...
although an input mask would probably be better, since it will control
the length, too, I think.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.