Results 1 to 3 of 3
  1. #1
    darwin is offline Novice
    Windows 8 Access 2013
    Join Date
    Apr 2015
    Posts
    28

    how to set standard value to yes for the Yes/no datatype

    hi I

    the standard value for the yes/no datatype = no



    I try to set the standard value to yes but I can not be allowed for yes ?

    how do I set it to yes ???


    Ahhh I have open the table, then I could not change to yes :-(

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    -1 is yes and 0 is no

  3. #3
    Rawb is offline Expert
    Windows 7 64bit Access 2010 32bit
    Join Date
    Dec 2009
    Location
    Somewhere
    Posts
    875
    You can also use True/False.

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

Similar Threads

  1. Criteria datatype error???
    By GraeagleBill in forum Programming
    Replies: 12
    Last Post: 05-04-2015, 11:01 AM
  2. Unexpected datatype
    By George in forum Access
    Replies: 6
    Last Post: 03-23-2015, 08:00 PM
  3. datatype date as text?
    By slimjen in forum Queries
    Replies: 36
    Last Post: 08-20-2014, 08:22 PM
  4. Problems with Currency Datatype
    By Perceptus in forum Programming
    Replies: 6
    Last Post: 03-27-2014, 02:28 PM
  5. Binary datatype
    By huBelial in forum Access
    Replies: 1
    Last Post: 04-04-2011, 02:02 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