Hiding certain characters in a text box (similar to password)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RussCRM - 01 Apr 2008 22:18 GMT

Is there a way to hide certain characters in a text box similar to
password?

For instance, I have a field with the social security number, but I
don't want the whole number visible. Is there a way to hide all but
the last four digits?

Reply to this Message

fredg - 01 Apr 2008 23:31 GMT

> Is there a way to hide certain characters in a text box similar to
> password?
>
> For instance, I have a field with the social security number, but I
> don't want the whole number visible. Is there a way to hide all but
> the last four digits?

Using an unbound copntrol,
=Right([SSN],4)
will show just the last 4 digits.

To display the SSN as XXX-XX-1234, with just the last 4 characters
readable, set the control source of an unbound text control to:
="XXX-XX-" & Right([SSN],4)

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

Pete D. - 01 Apr 2008 23:50 GMT

Use something like MYTEXTBOX = "***-**-" & right([SSAN],4) instead of using
the field name alone.

Reply to this Message