Home > Designing and creating databases > Creating a database > Changing field definitions > Changing field types

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.

Important  Changing the field type can permanently and irretrievably erase data.

To change a field type:

1.	With the database open, choose File menu > Manage > Database.

2.	In the Manage Database dialog box, click the Fields tab.

3.	If your database contains more than one table, select the appropriate table from the Table list.

4.	For Type, select a new field type.

See About choosing a field type.

5.	Click Change.

6.	Change the field options as needed.

See Setting options for fields.

7.	Continue making changes or click OK.

To change a field type in Table View:

1.	With the database open in Browse mode, click Table View in the layout bar.

2.	Right-click the column heading for the field and choose a new field type from the Field > Field Type shortcut menu.

The following table describes the effects of changing field types:

 

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.