How can I change a text field to a selection field?
You can change a text field to a selection field in a database.
About this task
Changing field type, for example from text to selection, does not affect current values for a particular field, even if these do not match the selection values.
Procedure
- Open the database.
-
Run a New Values report.
Run the New Values report before you change a field. This report gives you a list of all field values in the database.
- Based on the values found in the report, clean up your database. You can run a query to do this.
-
Change the field type to the Selection field.
The character limit for selection type fields is 100 characters.