hiding part of a social security number on a field

[Guest]

my reports include security number field. For security reasons, I would only
like the last 4 numbers to show in my report. How can show only portion of
the social security number and still show the rest

 

[John Vinson]

my reports include security number field. For security reasons, I would only
like the last 4 numbers to show in my report. How can show only portion of
the social security number and still show the rest

Use an expression

"***-**-" & Right([SSN], 4)

as the Control Source of the report textbox.

John W. Vinson[MVP]

 

[Todd Shillam]

my reports include security number field. For security reasons, I would only
like the last 4 numbers to show in my report. How can show only portion of
the social security number and still show the rest

Marcel,

You can use the Right() function in an expression to do this (here's an excerpt from Microsoft Access help):

Expression Description
=Left([ProductName], 1) Displays the first character of the value of the ProductName field.
=Right([AssetCode], 2) Displays the last 2 characters of the value of the AssetCode field.


Go to your report's Record Source property and invoke the query builder window, then create an expression like this:

Expr: Right([SSNNumber],4)

Then go back to your report in design mode and drop your expression onto the report (where you placed your SSN field); meanwhile, just remove your previous SSN field--should work.

Best regards,

Todd