Rocky Smolin
rockysmolin at bchacc.com
Fri Aug 1 20:24:01 CDT 2014
I'll find out soon enough. Actually, with a few lines of code I could change all of those fields in all the tables en masse. r -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Friday, August 01, 2014 2:00 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Creating default false in yes/no field I'm honestly not sure, Rocky. I just never take chances! LOL Charlotte On Fri, Aug 1, 2014 at 11:13 AM, Rocky Smolin <rockysmolin at bchacc.com> wrote: > When the new record is updated to the table, if the default of the > control if false, I'm thinking that the default of the control will > set the value of the field in the record to false. > > R > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte > Foust > Sent: Friday, August 01, 2014 11:04 AM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Creating default false in yes/no field > > Remember, though, that's for display purposes. If you want the value > to get into a new record, you need to use the field default. > > Charlotte > > > On Thu, Jul 31, 2014 at 10:47 AM, Rocky Smolin > <rockysmolin at bchacc.com> > wrote: > > > I'll probably use the default on the control - it'll be easier since > > I can define one checkbox and clone it x times. > > > > R > > > > > > -----Original Message----- > > From: accessd-bounces at databaseadvisors.com > > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte > > Foust > > Sent: Thursday, July 31, 2014 9:47 AM > > To: Access Developers discussion and problem solving > > Subject: Re: [AccessD] Creating default false in yes/no field > > > > Are you talking about the field or the checkbox control? I > > customarily set the field to a zero default, but the control handles > > a triple-state answer so you have to set its default as well. I > > can't recall if I've ever tried to set the control default using a > > normal form with a checkbox control, but it's worth a try. > > > > Charlotte > > > > Charlotte > > > > > > On Thu, Jul 31, 2014 at 8:16 AM, Rocky Smolin > > <rockysmolin at bchacc.com> > > wrote: > > > > > 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 > > > > > -- > > 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 > > -- > 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