August 28, 2013

Add Empty option in SharePoint drop down (Choice) column

Issue:You would like to have a blank/null option in the drop down. But SharePoint won't take SPACE as a valid option. You could specify the field to "not required" and initially it will be blank. But once some value has been specified there is no way to go back to blank. So what is the solution?
Solution:Use ASCII code 0129. It is an empty character that SharePoint will accept as a valid option but it appears empty on the drop down. To enter the character,hold down the ALT key and type the number 0129.

If you have any questions you can reach out our SharePoint Consulting team here.

3 comments:

  1. Lookup Plus for SharePoint 2013, It is more than Sharepoint Lookup. Cascaded Lookup, Filtered lookup, Cross-site Lookup /drop down/ and
    some controls are free. ("Create new item" link) Visit, http://www.azu.mn
    Or watch the channel http://www.youtube.com/watch?v=70-hXWY6ARY&list=PL-5v3e65O1cFMddgCpzIURE_UAsL-oDdW

    ReplyDelete
  2. Very useful, thank you for this quick tip :)

    ReplyDelete