Results 1 to 5 of 5
  1. #1
    RawToast is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2014
    Posts
    7

    List Box with NULL option

    I have a table for holding client responses to a questionnaire. 10 of the fields in this table are List Boxes with options "Yes", "No", and "Blank/Other". The "Blank/Other" option is supposed to be reserved for forms handed in where the field has been intentionally left blank. If the form has not been handed in at all, I want the fields to just be NULL. The problem is that if someone accidentally fills out information for a row that should all be NULL, there is no way to correct it. I have tried adding NULL (no quotations) as an option in the list box, but this does not work. I have also tried adding "" as an option, but no luck there either.

    tl;dr: How do I add an option in a list box to leave a field NULL?

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870
    You can try this link for ideas.

    Let us know if any of the ideas/suggestions work for you.
    Good luck.

  3. #3
    RawToast is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2014
    Posts
    7
    Quote Originally Posted by orange View Post
    You can try this link for ideas.

    Let us know if any of the ideas/suggestions work for you.
    Good luck.
    Thank you for the reply. Unfortunately, I was not able to find a solution in the thread you shared. I would rather not have to have users use a VBA script in order to make a field NULL. I am looking for a way to add a NULL option to the List Box, but I do not know what to enter in the Row Source in order to accomplish this.

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870
    You may want to research what NULL is. To start see http://databases.about.com/cs/sql/a/aa042803a.htm

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    Users can select the saved value and Delete.

    Is the combobox RowSource a Value List? I don't see any way to force Null as a Value List item.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Lookup list with a write-in option
    By KayTee in forum Macros
    Replies: 10
    Last Post: 06-19-2014, 11:37 AM
  2. Forms, Combox Edit List Option
    By RoundTrip in forum Access
    Replies: 7
    Last Post: 03-02-2014, 09:13 PM
  3. Replies: 8
    Last Post: 11-18-2013, 03:36 AM
  4. Replies: 6
    Last Post: 07-20-2011, 11:54 AM
  5. Replies: 8
    Last Post: 07-06-2011, 11:20 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums