Wednesday, June 15, 2011

Empty option in sharepoint drop down 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?

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.

Enjoy!

3 comments:

  1. Sadly, this is still the best advice for this problem that exists (Nov. 2012).

    ReplyDelete
  2. thanks a lot, it's work for me :-)

    ReplyDelete
  3. Thanks, seems to be the only solution.

    ReplyDelete