Access report with output display mask(digits turned to letters)

[Lifeseeker]

Hi there,

Would it be possible to export an Access report with a column of values masked?

This column contains sensitive identifying information, so I would like to somehow "hide" all the digits.

So I'm thinking having some kind of code sheet (i.e. 1 = A, 2 = B, 3 = C)

So the on the report, instead of displaying digits, letters are displayed.

Originally value in this column is a 10-digit number.

Any comment/feedback much appreciated.

 

[RuralGuy]

You can easily create your own User Defined Function (UDF) in a standard module that converts the value for you and use it in your Report.