User manual

Table Of Contents
86 Chapter 9 Using Fields
Changing an Existing Field from One Type to Another
You can change the type of some fields to another. Automatic counter, location, and
address fields, and any fields you access in a shared database can’t be changed to a
different type.
The information in the table below also applies to changing the data type of columns
in simple list fields and columns in the notes section of related data fields.
To change an existing field from one type to another:
1 Select a column name in table view.
2 Click near the right edge of a column header.
3 Choose Change To, then select a field type from the list.
Working with List Fields
Some types of list fields (address, phone number, email address, URL, and IM account)
have a pop-up menu from which you can quickly perform actions such as displaying
the selected phone number in large type, getting directions to or from the selected
address, and displaying a map for the selected address.
Convert
from:
Convert
to:
Tex t
Number Choice Checkbox Time Date Duration Currency Rating Phone
Other
list
fields
Calculation;
Encrypted;
Media
Text
Number
Choice
Checkbox
Media
Time
Date
Duration
Calculation
Currency
Rating
Encrypted
Phone
number
Email
address
URL
IM account