I created a table with many fields in Design View with data type Short Text. Even though I wanted dropdowns, I did not like going through the Lookup Wizard for every item and figured I would go back and do that later. However, when I go into design view and change the data type to Lookup Wizard, in Datasheet View I cannot edit the list items.
While I know that I can add the items I want in the dropdown within the Lookup Wizard, the issue with this is that there is a 50 character limit, while editing the list item seemingly has no character limit or a much larger one. For a little while, it seems as if the Edit List Items button was appearing for my converted fields, but now it does not appear for many of them. The best way I have found so far to recover the ability to Edit List Items is to create a new field with a name close to the original field, and then delete the original field, but this is problematic as it kicks me back out to the left hand side of the form.
