::Online Microsoft Office,Web ,Graphic and many more Tutorials
Field Properties
If the DataType property is set to Text, enter a number from 0 to 255. The default setting is 50.
If the DataType property is set to AutoNumber, the FieldSize property can be set to Long Integer or Replication ID.
If the DataType property is set to Number, the FieldSize property settings and their values are related in the following way.
Setting
Description
Decimal precision
Storage size
Byte
Stores numbers from 0 to 255 (no fractions).
None
1 byte
Decimal
Stores numbers from –10^38–1 through 10^38–1 (.adp)
Stores numbers from –10^28–1 through 10^28–1 (.mdb)
28
12bytes
Integer
Stores numbers from –32,768 to 32,767 (no fractions).
None
2 bytes
Long Integer
(Default) Stores numbers from –2,147,483,648 to 2,147,483,647 (no fractions).
None
4 bytes
Single
Stores numbers from
–3.402823E38 to –1.401298E–45
for negative values and from
1.401298E–45 to 3.402823E38 for positive values.
7
4 bytes
Double
Stores numbers from
–1.79769313486231E308 to
–4.94065645841247E–324
for negative values and from
4.94065645841247E–324 to
1.79769313486231E308 for positive values.
15
8 bytes
Text and Memo Data Types
Symbol
Description
@
Text character (either a character or a space) is required.
&
Text character is not required.
<
Force all characters to lowercase.
>
Force all characters to uppercase.
Input Mask
The input mask is used to ease the data entry and to control the values that users are permitted to introduce in the field. E.g, you can create an input mask for a Telephone number field that shows the exactly how a new number should be introduced:(___)-(___)-(____).
Access has an input mask wizard that helps us to establish this property, to enter the wizard click on the button that appears to the right of the property once this property is activated.
For Example
Input Mask : "(+977)-("00#")-("000000#")"
You can define an input mask by using the following characters.
Character
Description
0
Digit (0 to 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; spaces are displayed as blanks while in Edit mode, but blanks are removed when data is saved; plus and minus signs allowed).
L
Letter (A to Z, entry required).
?
Letter (A to 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).
The following table shows some useful input masks and the type of values you can enter in them.
