Member Avatar for peterv200

I have a control in an access database that holds credit card numbers.

I want to format the control so that it only displays the last 4 digits the first 12 digits just displaying an X

so that it will appear like this XXXX XXXX XXXX 1245

What is the best way to achieve this.

Many thanks for your help

Regards

Peter

  • 2 Contributors
  • 1 Reply
  • 64 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by kb.net
Member Avatar for kb.net

Hi,

I think there is no way to format part of the field directly in the table. Accordingy you may need to put it in a query and show it as:
Format(Left([CredNum],11),"XXXX XXXX XXXX " & Right([CredNum],4))
Noting that I have included the spaces into the text.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.