::
Introduction
::
Database principles
::
Tables
::
Queries
::
Data security
::
Glossary
::
Resources
::
Student Files
:: Contact
:: Back to Main Site
:: Site
Map |
Microsoft Access - Class 2 - Part VI
|
>
Back |
Input Masks
Text, number, date/time, and currency fields can have a field Input
Mask property that specifies a format in which data must be entered.
Do not confuse an input mask with a format, which specifies how
data is displayed, not how it is entered.
You can create your own input masks by typing the input mask characters
shown in the following table.
|
Character
|
Meaning
|
|
|
|
|
0
|
Number required |
|
9
|
Number or space can be entered but is not required |
|
#
|
Number, plus or minus sign, or space can be entered
but not required |
|
L
|
Letter required |
|
?
|
Letter can be entered but is not required |
|
A
|
Letter or number required |
|
a
|
Letter or number can be entered but is not required |
|
&
|
Any character or a space required |
|
C
|
Any character or a space can be entered but is
not required |
|
<
|
Characters that follow converted to lowercase |
|
>
|
Characters that follow converted to uppercase |
|
!
|
Characters fill from right to left rather than
from left to right. Can be
used when characters on the left are optional, and can be included
anywhere in the mask
|
|
\
|
Following character is displayed literally rather
than read as a code |
Print this page
|
