How to add a blank choice on a drop down menu choice list column
This seems like it should be easy, but I have not been able to figure it out. Let's say I have a list with a column of type "Choice" and I use a drop-down menu. How can I make it so that a user can choose a blank choice if they don't know what choice to pick? It's easy for any new items. You just set the default value to be blank and any new items will show the blank choice as default. But if you create a new item and choose a non-blank choice and then later try to edit it and make that field blank, there is no blank option anymore.
August 4th, 2008 9:25pm

If you allow users to add their own values (a specification when creating the Choice field) then they will be able to add a single space as their "own value".I have herehttp://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/V%20Books.aspxsuch a Choice field for whether a book is OUT or not.Default is blank. The only Choice value is OUT but "Allow Fill-in Choices" is set to Yes.(So if a book has been marked as OUT but then gets out of print or otherwise unavailable, I can and do mark it as blank again)
Free Windows Admin Tool Kit Click here and download it now
August 5th, 2008 7:36am

Mike,Thanks for the response. I was hoping to avoid that, but it seems to be the only out-of-the-box way to do it. Unfortunately it looks like this simple feature may require some custom programming.
August 5th, 2008 5:23pm

Robert,The solution I have used to workaround this is to create a choice called "Unassigned". I call it this so that it usually ends up at or near the bottom of the drop-down menu. Then I offer some instructions under the column description informing folks that that they should pick this option if they cannot find an option that is more applicable. The advantage to doing this is that I often found a need to filter out these results from the rest and this can easily be done with Equals or Does Not Equal " Unassigned"Hope this helps..
Free Windows Admin Tool Kit Click here and download it now
August 5th, 2008 8:37pm

Fred,Thanks for the response. That's a good idea, but I'm not sure if it will work in my specific situation. We have a custom list of contacts that Marketing uses to build a mailing list. One of the fields is a drop-down menu for suffix. They use certain fields to pull into a template to build the mailing addresses. I need to see how they transfer the data to ensure that we don't have something like "John Smith Unassigned" printed on an envelope going out to a customer.Thanks,Rob
August 6th, 2008 11:46pm

Ahh,But you could also create a calculated column to use in the mail merge that turns your default empty choice into an empty string leaving the others intact!HTH,--Doug Warehttp://www.elumenotion.com/blog
Free Windows Admin Tool Kit Click here and download it now
August 7th, 2008 6:59am

Sneaky !But why not, it would work.
August 7th, 2008 5:26pm

Doug Ware said: Ahh,But you could also create a calculated column to use in the mail merge that turns your default empty choice into an empty string leaving the others intact!HTH,--Doug Warehttp://www.elumenotion.com/blogExcellent idea! I think that will work nicely. Thanks for your help!
Free Windows Admin Tool Kit Click here and download it now
August 7th, 2008 7:49pm

I finally discovered another way to this, although it does have a drawback. If you are familiar with C# and the SharePoint API you can programatically add choices to a list choice field. The only problem is that if you go back and modify the choices through the normal SharePoint interface it will remove your blank choice. You would have to re-execute the code every time you make a modification. I guess it's not a big deal if you rarely have to modify the choices.SPSitesiteCollection=newSPSite("http://yoururl");SPWebweb=siteCollection.OpenWeb();SPFieldChoicemyField=(SPFieldChoice)web.Lists["YourList"].Fields["TestChoice"];myField.Choices.Insert(0,string.Empty);myField.Update();web.Dispose();siteCollection.Dispose();This inserts a blank choice at the beginning of the list.
November 18th, 2008 11:07pm

Another Possible solution that I just tried, is to create a hidden column with an empty default value, in my case I just named the column Empty ;o)For the Choice box, now add a value like X/XXX and specify in description somewhere on the form that this value is to be used if the person wishes to cleara choice.Thencreate a workflow looking on changes:IF Field:value equals X THEN set field:value to List:EmptyThis will set the field to an empty value.
Free Windows Admin Tool Kit Click here and download it now
July 2nd, 2009 5:00pm

I struggled with this too.If you have a Drop Down List with either 1 or more than 1 item and want an additional blank; place the cursor after the last item hit ENTER and viola.Rock On
February 2nd, 2010 11:46pm

This will give you a blank in the NewItem form. It will not give you a blank in the Edit form.
Free Windows Admin Tool Kit Click here and download it now
February 17th, 2010 11:56pm

Choice fields are often used within SharePoint lists to display choice options like Gender, Status, etc and these choice options can be displayed using Radio Button and Dropdown formats. Provided below is a code sample in C#.Net which describes the creation of a choice field programmatically using SharePoint API. /* get the newly added choice field instance */ SPFieldChoice chFldGender = (SPFieldChoice)lst.Fields["Gender"]; Any suggestions are appreciated.Hope it did answer the question. Cheers, Eliza
June 18th, 2010 11:49am

We recently upgraded to SP2010. Our existing lists with choice columns still have this issue when User wants to change an existing item to a blank. Is there a solution somewhere in SP2010 out of the box without coding?Teresa
Free Windows Admin Tool Kit Click here and download it now
February 24th, 2011 7:37pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics