S
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!
(123456789)....how do I make it show on a form like this
(XXX-XX-6789)? Someone please help!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
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.
="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.
K
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)
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)
G
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
.