A reader wants to know how to create a mask for a credit card.
Q: Melody Overstreeet writes: “How do you create a mask for a credit card? I want the last for digits to show and the rest I want to be an *”
A: I like to use the expression below in a query; the SecureCreditCardNo field can then be placed on a form or report:
SecureCreditCardNo: IIf([CreditCardNo]<>“”,”********” & Right([CreditCardNo],4),””)
