Effects of changing field types

Changing a field type changes the kind of data the field can contain. It also affects how you find and sort information that uses that field. For example, if you change a date field to a text field, you can type other information in the field besides a date, but you will no longer be able to sort chronologically.


When you change	This happens
A text field to a number, date, time, or timestamp field	The first 255 characters that can be converted are moved to the first line, deleting any remaining characters. Values that can't be used as dates or times are displayed and indexed as question mark (?). Date and time fields can't contain text.
A number, date, time, or timestamp field to a text field	Existing data isn't changed.
A container to another field type, or remove the option for global storage	Existing data in the field is deleted.
Any field to a container field or to a field with global storage	Existing data is deleted.
Any field type to a calculation or summary field	Existing data is replaced with the results of the formula or summary you specify.
A field used in a summary to a field type that can't be used in a summary	You see an alert. You must change the summary so it doesn't include the field or delete the summary field before changing the field type.
A field used in a relationship	You might not be able to change the field type if the field is used as a match field in a relationship and the new field type cannot be used as a match field in a relationship. Container fields cannot be used as match fields. Fields with global storage and summary fields cannot be used as key fields. Fields in which indexing is disabled cannot be used as key fields.