By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,345 Members | 1,667 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,345 IT Pros & Developers. It's quick & easy.

Need help with Input mask

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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-----

Nov 12 '05 #2

P: n/a
"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
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.