Groups | Search | Server Info | Login | Register

Groups > comp.databases.ms-access > #1248

Re: Masking Characters

Cross-posted to 3 groups.

Show all headers | View raw

Instead of trying to manipulate the view of the SSN in the form, manipulate 
it in a Query and display the contents of the Query in the Form.  Even if 
you use the SSN as the record key (which is Not A Good Idea, BTW, for 
multiple reasons), you could not display the actual SSN, only the formatted 
SSN which you create in a Calculated Field.  This will eliminate the problem 
with continuous forms.

 -- 
  Larry Linson, Microsoft Office Access MVP
  Co-author: "Microsoft Access Small Business Solutions", published by Wiley
  Access newsgroup support is alive and well in USENET 
comp.databases.ms-access

"Neil" <neil.ginsberg+newsgroup@gmail.com> wrote in message 
news:ipsb0j$vks$1@dont-email.me...
> 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 — Previous 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