Database Reference
In-Depth Information
2
The Field Properties area shows the properties you can set for the Short Text data type.
TIP
If you use only five-digit ZIP codes, the Number data type is fine. But by setting
it to Short Text, you can enter ZIP+4 codes or the letter-number postal codes used in
Canada and some other countries.
Now let's change some of the properties for the PostalCode field.
9
In the box to the right of
Field Size
, double-click
255
, and enter
10
to limit the
entries in this field to 10 characters.
10
Change the
Field Size
property of the following fields as shown:
50
50
30
FirstName
City
Phone
LastName
50
State
20
TIP
Sometimes changing the field properties of a table that already contains data
can produce unanticipated results. If you make a change to a field property that
might cause data to be lost (for example, if you make the Field Size property smaller
than one of the field's existing values), Access warns you of this problem when you
attempt to save the table. For more information, see Chapter 6, “Maintain data
integrity.”