Need help with Input mask

[Ut Chau]

Okay, basically I plan to input SS# and want it be displayed as
XXX-XX-1234 because sometimes I have to print reports and I can't let
the full SS# out. Is this possible? thanks

[MGFoster]

Ut Chau wrote:

Okay, basically I plan to input SS# and want it be displayed as
XXX-XX-1234 because sometimes I have to print reports and I can't let
the full SS# out. Is this possible? thanks

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
That wouldn't be covered by the TextBox's Input Mask property. You'd
have to change the format of the SSN before it reached the report. You
could do that in the query that is the report's RecordSource. E.g.:

SELECT "XXX-XX-" & Right(SSN, 4) As MySSN, ... etc.

- --
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQGzTX4echKqOuFEgEQKiigCeIfl/kbgnDTikWXWc9ElPY2J4aDoAoNaC
xdYROP9SKdgYQeNhjnW8te6l
=M8A0
-----END PGP SIGNATURE-----

[Dave Brydon]

"Ut Chau" <uc***@pacbell.net> wrote in message
news:89**************************@posting.google.c om...

Okay, basically I plan to input SS# and want it be displayed as
XXX-XX-1234 because sometimes I have to print reports and I can't let
the full SS# out. Is this possible? thanks

In your query design, place the following into a new columns field: SSNo:
"xxx-xx-" & Right([SSN],4)
Change the "SSN" to reflect the name of your field.

HTHs,

Dave