social security number

Hello!

I´m 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

re: social security number

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" <kif@nospam.katedral.se> wrote in message
news:o4DOb.45278$mU6.168684@newsb.telia.net...[color=blue]
> Hello!
>
> I´m 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[/color]
some[color=blue]
> help, I would get very happy.
>
> /Sincerely Kif
>
>[/color]

re: social security number

"Kif" <kif@nospam.katedral.se> wrote in message news:<o4DOb.45278$mU6.168684@newsb.telia.net>...[color=blue]
> Hello!
>
> I´m 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[/color]

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.