Andy Lacey
andy at minstersystems.co.uk
Thu Nov 18 15:53:45 CST 2010
Thanks for the replies. It's as I thought. Setting a table-level default of False should do it I guess. Is there anything else that might trip me up here, ie moving a db developed under A2K to a A2003 environment? Andy -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: 18 November 2010 17:01 To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] YesNo Default value I always set the default either in the field in the table or in the control on the form. Or sometimes set the default in code in the _Open event of the form - both for check boxes and option frames. I never liked seeing all of the radio buttons or the check box grayed out. And, yes, if the check box or option frame value is null it causes problems. Which you could trap for, of course, but it seemed cleaner to set a default and I find that usually, there's a logical default value. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andrew Lacey Sent: Thursday, November 18, 2010 8:39 AM To: Access Developers discussion and problem solving Subject: [AccessD] YesNo Default value I'm looking for confirmation of what i think is a probelm I've accidentally caused (does anyone cause them on purpose he muses). Developed a system in A2K. Being used on A2003. What I think is causing a problem is that under A2K and earlier I could omit the Default Value for YesNo fields and they defaulted to False. Am I right in thinking that under A2003 the default Default Value (as t'were) is now Null? Looks to be the case and causing my code some grief. Andy -- 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