Results 1 to 5 of 5
  1. #1
    HackerMan is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    May 2018
    Posts
    7

    Default values change once I enter/change value in any field

    I have set check/drop down box default values to blank or null, as in I don't want the default to be "No".

    Whenever I enter a value into the primary key or change any field, all the defaults I have set change/revert to No.

    how can I enter information/change fields in a form while keeping all other field defaults as null? and why does this happen?

  2. #2
    Beetle is offline Unrelatable
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    Camp Swampy (Denver, CO)
    Posts
    207
    Are we talking strictly about boolean (yes/no) fields here?

    Where have you set the Default values? At the table or form level?

    If they are all check boxes, have you set the Triple State property?

  3. #3
    HackerMan is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    May 2018
    Posts
    7
    Quote Originally Posted by Beetle View Post
    Are we talking strictly about boolean (yes/no) fields here?

    Where have you set the Default values? At the table or form level?

    If they are all check boxes, have you set the Triple State property?

    Yes, these were just the Yes/No type of field.
    I set the defaults at the table level, not at the form level.

    I did not change any triple state property - I'm not familiar with that, sorry I'm very novice with Access.

  4. #4
    Beetle is offline Unrelatable
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    Camp Swampy (Denver, CO)
    Posts
    207
    By default, boolean fields are dual state, meaning they are only True or False (yes or no), with Null not being an option. In your form, open the property sheet for your check box, go to the Data tab and set the Triple State property to Yes. See if this solves your problem.

  5. #5
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,801
    The only affect this property has is how the control looks when the field value doesn't contain a value. Yes/No fields cannot contain Null values according to AB
    http://allenbrowne.com/NoYesNo.html,
    so there is no "option" for null, thus there has to be another reason for the problem. You need to explain more about the form and any code that might be behind it. For example, one thing that can cause this is if you try to put unbound combo or checkboxes on a continuous form. What you do to one will propagate through all.
    Last edited by Micron; 05-14-2018 at 06:06 PM. Reason: correction
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. Replies: 1
    Last Post: 06-25-2016, 02:00 PM
  2. Change default printer
    By LonghronJ in forum Modules
    Replies: 2
    Last Post: 02-03-2016, 03:01 PM
  3. Replies: 10
    Last Post: 10-07-2015, 05:31 PM
  4. Replies: 1
    Last Post: 09-27-2013, 09:44 AM
  5. Replies: 3
    Last Post: 07-20-2012, 11:41 AM

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