Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.
Is there a way to remove choices from a multiple-choice text field? Is this still possible when you set the field to allow users to add choices?
1. In the table bar on any application page, click the table containing the field. Within the menu that appears, select Customize --tablename-- table > Fields.
2. Click the field's name that you want to modify.
3. In the "Choices" text box, select the choices that you no longer want included in the list, press the DELETE key, and then click "Apply Changes".
This works whether or not users can enter choices.
If the choice is not used by any records, it is permanently removed. However, if it is used by a record, it will not appear as a choice in most cases, but will appear as a choice when you select the record that still uses it. If you select a different choice the next time you go to that record, it will not be in the list. But, if you save that record with the deleted choice still selected, it will add the deleted choice back into the list.
Tip: You might also want to use "Find and Replace" to clean up your data.
Browse by Category
Knowledge Base Categories
- Accounts (35)
- Application (45)
- E-Mail (7)
- Fields (41)
- Forms (20)
- Formulas (18)
- General (68)
- Other Product (7)
- Pages (1)
- Product (5)
- Reports (15)
- Roles (4)
- Search (1)
- Tables (6)