G
Guest
How can I create a mask that will put ************1234 for a credit card in
Microsoft Access
Microsoft Access
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
John Nurick
Hi Melody,
Would you like to give some more information about what you're trying to
achieve?
If this is for data input, hiding the first 12 digits will make the
user's task much more difficult, and if it's for security it seems more
secure to exclude the first 12 digits altogether, using a calculated
field like
MaskedNumber: "************" & Right([CardNumber], 4)
On Sat, 20 Nov 2004 08:27:03 -0800, "Melody Overstreet" <Melody
Would you like to give some more information about what you're trying to
achieve?
If this is for data input, hiding the first 12 digits will make the
user's task much more difficult, and if it's for security it seems more
secure to exclude the first 12 digits altogether, using a calculated
field like
MaskedNumber: "************" & Right([CardNumber], 4)
On Sat, 20 Nov 2004 08:27:03 -0800, "Melody Overstreet" <Melody
S
StCyrM
Hi Melody
Here's the rules for masks..
Best Regards
Maurice St-Cyr
Micro Systems Consultants, Inc.
Character Description
0 Digit (0 through 9, entry required; plus [+] and minus [-] signs not
allowed).
9 Digit or space (entry not required; plus and minus signs not allowed).
# Digit or space (entry not required; blank positions converted to spaces, plus
and minus signs allowed).
L Letter (A through Z, entry required).
? Letter (A through Z, entry optional).
A Letter or digit (entry required).
a Letter or digit (entry optional).
& Any character or a space (entry required).
C Any character or a space (entry optional).
.. , : ; - / Decimal placeholder and thousands, date, and time
separators. (The actual character used depends on the regional settings
specified by double-clicking Regional Settings in the Windows Control
Panel.)
< Causes all characters that follow to be converted to lowercase.
from left to right. Characters typed into the mask always fill it from left
to right. You can include the exclamation point anywhere in the input mask.
\ Causes the character that follows to be displayed as a literal
character. Used to display any of the characters listed in this table as
literal characters (for example, \A is displayed as just A).
Password Setting the InputMask property to the word Password creates a
password entry text box. Any character typed in the text box is stored as
the character but is displayed as an asterisk (*).
Here's the rules for masks..
Best Regards
Maurice St-Cyr
Micro Systems Consultants, Inc.
Character Description
0 Digit (0 through 9, entry required; plus [+] and minus [-] signs not
allowed).
9 Digit or space (entry not required; plus and minus signs not allowed).
# Digit or space (entry not required; blank positions converted to spaces, plus
and minus signs allowed).
L Letter (A through Z, entry required).
? Letter (A through Z, entry optional).
A Letter or digit (entry required).
a Letter or digit (entry optional).
& Any character or a space (entry required).
C Any character or a space (entry optional).
.. , : ; - / Decimal placeholder and thousands, date, and time
separators. (The actual character used depends on the regional settings
specified by double-clicking Regional Settings in the Windows Control
Panel.)
< Causes all characters that follow to be converted to lowercase.
! Causes the input mask to display from right to left, rather thanCauses all characters that follow to be converted to uppercase.
from left to right. Characters typed into the mask always fill it from left
to right. You can include the exclamation point anywhere in the input mask.
\ Causes the character that follows to be displayed as a literal
character. Used to display any of the characters listed in this table as
literal characters (for example, \A is displayed as just A).
Password Setting the InputMask property to the word Password creates a
password entry text box. Any character typed in the text box is stored as
the character but is displayed as an asterisk (*).