I have a custom list, in a column the users must enter a month from a drop-down menu(January, February, ... ), but when they use datasheet view to register the month manual I get different text formats (JANUARY, January and january), is there any way to restrict users from register only this type(January). I cant disable datasheet view

  • 1
    What's the SharePoint version, I tried this with choice field and quick view that working properly at SharePoint 2013 Sep 8, 2016 at 21:27
  • 2
    Is the Enter your own choice enabled on the choice column?
    – Mike
    Sep 8, 2016 at 22:31

1 Answer 1


The dropdown field should not allow users to enter different values:

  • If it is small/big casing issue, it should adjust automatically: enter image description here

enter image description here

  • If the user trie to fill the field, it should show him dropdown (even in datasheet view): enter image description here

  • And if the user enters an incorrect value by the ingenuity of copy-paste, then it should show him an error and not allow to save changes with wrong input: enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.