Format Number

[Ace]

Hi Everyone,

I have a product ID number that looks similar to the following.

1234 4351 0076 8902

What I would like to do is format the number dynamically through code so that it displays like this on the form.

xxxx xxxx xxxx 8902

I would appreciate any help. Thank you.

[kleinma]

Originally posted by Ace
Hi Everyone,

I have a product ID number that looks similar to the following.

1234 4351 0076 8902

What I would like to do is format the number dynamically through code so that it displays like this on the form.

xxxx xxxx xxxx 8902

I would appreciate any help. Thank you.

assuming it will always be the same length (credit card right??)

Dim str As String
str = "1234 4351 0076 8902"
MsgBox "XXXX XXXX XXXX " & Right(str, 4)