SS#

[Steve]

I have a field in a table that contains a SS#
(123456789)....how do I make it show on a form like this
(XXX-XX-6789)? Someone please help!

 

[Roger Carlson]

Put the following in the control source of a textbox.

="XXX-XX-" & Right([SS#],4)

Be sure to name the textbox something other than SS#, or you will get an
error. The text box cannot be named the same as any field in an expression.

 

[Karen]

Steve,

Try this (I'm assuming the SS# field is called SSNumber for this example)

SocialSecurity = left(SSNumber,3) & "-" & mid(SSNumber,4,2) & "-" &
right(SSNumber,3)

 

[Guest]

Thanks...that was great!

-----Original Message-----
Steve,

Try this (I'm assuming the SS# field is called SSNumber for this example)

SocialSecurity = left(SSNumber,3) & "-" & mid (SSNumber,4,2) & "-" &
right(SSNumber,3)

--
Karen



.