[AccessD] Creating default false in yes/no field

Dan Waters df.waters at outlook.com
Thu Jul 31 10:21:54 CDT 2014


IIRC, all yes/no fields in Access tables are defaulted to False when the
field is created.  It might not display as False, but it will operate that
way unless you change it to True.  It's always worked that way for me.
There is no Null value for a yes/no field in an Access table, just True or
False.

However, SQL Server tables do allow a Null value for a yes/no field, but
that won't be changeable in an ODBC table link anyway.

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Thursday, July 31, 2014 10:16 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Creating default false in yes/no field

Yeah I can do that for each field I create but if there's a way to set False
as the default it would save a lot of tedious keystrokes and mouse clicks.

R
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: Thursday, July 31, 2014 8:14 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Creating default false in yes/no field

Hi Rocky,

In the property screen for a yes/no field just enter True or False as the
default value.  

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Thursday, July 31, 2014 10:02 AM
To: 'Access Developers discussion and problem solving'; 'Off Topic'
Subject: [AccessD] Creating default false in yes/no field

Dear List:
 
Is there a way to set the default of a yes/no field in a table when creating
that field in design view.  I am using A2003 and the default appears to be
null.
 
MTIA
 
Rocky Smolin
Beach Access Software
858-259-4334
www.bchacc.com <http://www.bchacc.com/> www.e-z-mrp.com
<http://www.e-z-mrp.com/>
Skype: rocky.smolin
 
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list