Using a mask when there is not a set # of digits.

[Eliz309]

I am trying to format a credit card number field to automatically put a space after every 4th number. I have created a mask and it works well except that all credit card numbers are not the same number of digits. So if I make the mask for 16 and enter a 14 digit number, it adds numbers. Is there a way that I can get around this?

[CyborgSam]

Assuming a text field named CC#, create a calculation field with:

Left(CC#, 4) & " " &

Middle(CC#, 5, 4) & " " &

Middle(CC#, 9, 4) & " " &

Middle(CC#, 13, 4) & " "

Is this what you wanted?

[Eliz309]

That is exactly what I was looking for!

Thank you