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