Input Mask/Format type

J

Joseph

Help!!

What method should I use to hide or display asterisks in
the first four Social Security number field
like this==> ***-*0-1234.

I attempeted password and this method will hide all of
the numbers.
 
J

John Nurick

Hi Joseph,

Assuming you're storing the SSN as a string, try

S = "123-45-6789"
?Format(S, "!\*\*\*-\*&&&&&&")
***-*5-6789
 
Top