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

  1. Open the database.
  2. 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.
  3. Based on the values found in the report, clean up your database. You can run a query to do this.
  4. Change the field type to the Selection field.
    The character limit for selection type fields is 100 characters.