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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top