Formating a control in Access

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 374,634 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,477 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MS Access and FileMaker Pro advertiser:

Thread Tools Display Modes

Views: 583 | Replies: 1

•

Join Date: Dec 2007

Posts: 1

Reputation: peterv200 is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

peterv200

Offline

Newbie Poster

Formating a control in Access

Dec 7th, 2007

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

•

Join Date: Aug 2007

Location: KSA

Posts: 139

Reputation: kb.net is an unknown quantity at this point

Rep Power: 1

Solved Threads: 26

kb.net

Offline

Junior Poster

Re: Formating a control in Access

Dec 9th, 2007

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.

It is never about the number of languages you know, you either have the logic of programming or you don't ...

Some of the codes I post are collected from different sites during the past couple of years, so I would like to thank them for their help and for enabling me to help.