Input Mask/Format type

  • Thread starter Thread starter Joseph
  • Start date Start date
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.
 
Hi Joseph,

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

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