Microsoft Office Tutorials and References
In Depth Information
Field Properties for Making Sure That Data Entries Are Accurate
in the Design view window) and instructions for using them wisely. Which
properties you can assign to a field depends on which data type the field
In the Field Size box for Text fields, enter the maximum number of
characters that can be entered in the field. Suppose that the field you’re dealing
with is ZIP Code, and you want to enter five-number ZIP codes. By entering
5 in the Field Size text box, only five characters can be entered in the field. A
sleepy data-entry clerk couldn’t enter a six-character ZIP code by accident.
For Number fields, select a value for the field size from the drop-down list.
Table 2-2 describes these field sizes.
Numeric Field Sizes
Field Size Description
Byte An integer that holds values from 0–255.
Integer An integer that holds values from -32,768– +32,767.
Long Integer An integer that holds values from -2,147,483,648– +2,147,483,647.
Single A floating point number that holds large values up to
7 significant digits.
Double A floating point number that holds large values up to
15 significant digits.
Replication ID* A globally unique identifier (GUID) required for replication;
this number is generated randomly.
Decimal A number with defined decimal precision. The default precision
is 0, but you can set the scale up to 28.
*Not supported by the .accdb file format.
The Single, Double, and Decimal field size options hold different ranges of
numbers. For now, if you need to store numbers after the decimal point,
choose the Double field size so that you cover most situations.
Earlier in this chapter, “Deciding how the data in fields is displayed” explains
the Format property. Click the drop-down list and choose the format in
which text, numbers, and dates and times are displayed.