|Subject:||need to mask part of cell when printed|
|Posted by:||Bonnie (bonn…@jpyro.com)|
|Date:||Tue, 7 Oct 2003|
Due to a new law that takes effect 1 Januar 2004, I cannot
print all credit card digits when I create a receipt. I
can and must print the last 4 digits.
Is there anyway to do this? I found a LEN function, which
will tell me how many characters a field contains, but I
don't know where to go from there to not print the first
[LEN - 4] characters.
As an alternative, is there someway to create a new field
that would extract only the last 4 characters from the
field. This may well be the better answer because the LEN
function requires the input of a Cell Number [e.g., A4],
which would not be known for a Word mail merge use.
This may well become a problem for many small businesses
in the very near future.