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]

Re: Need help with Input mask

Ut Chau wrote:
[color=blue]
> 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[/color]
-----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:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

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

iQA/AwUBQGzTX4echKq OuFEgEQKiigCeIf l/kbgnDTikWXWc9El PY2J4aDoAoNaC
xdYROP9SKdgYQeN hjnW8te6l
=M8A0
-----END PGP SIGNATURE-----

[Dave Brydon]

Re: Need help with Input mask

"Ut Chau" <uchau@pacbell. net> wrote in message
news:893890d2.0 404011654.2e594 079@posting.goo gle.com...[color=blue]
> 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[/color]

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