Masking Characters

From	"Neil" <neil.ginsberg+newsgroup@gmail.com>
Newsgroups	comp.databases.ms-access, microsoft.public.access, microsoft.public.access.forms
Subject	Masking Characters
Date	2011-05-04 14:55 -0500
Organization	A noiseless patient Spider
Message-ID	<ipsb0j$vks$1@dont-email.me> (permalink)

Cross-posted to 3 groups.

Show all headers | View raw

In an Access form, I need to hide part of a SSN in certain conditions, and 
show the whole thing in others. In other words, sometimes:

123-45-6789

and other times:

***-**-6789

Can that be done with the Format property?

Back to comp.databases.ms-access | Previous | Next — Next in thread | Find similar

Thread

Masking Characters "Neil" <neil.ginsberg+newsgroup@gmail.com> - 2011-05-04 14:55 -0500
  Re: Masking Characters John W. Vinson <jvinson@STOP_SPAM.WysardOfInfo.com> - 2011-05-04 14:59 -0600
    Re: Masking Characters "Neil" <neil.ginsberg+newsgroup@gmail.com> - 2011-05-04 17:16 -0500
      Re: Masking Characters John W. Vinson <jvinson@STOP_SPAM.WysardOfInfo.com> - 2011-05-04 16:47 -0600
        Re: Masking Characters "Neil" <neil.ginsberg+newsgroup@gmail.com> - 2011-05-04 22:14 -0500
          Re: Masking Characters John Spencer <JSPENCER@Hilltop.umbc> - 2011-05-05 08:29 -0400
  Re: Masking Characters "Access Developer" <accdevel@gmail.com> - 2011-05-05 13:22 -0500

csiph-web