Charlotte Foust
charlotte.foust at gmail.com
Fri Aug 1 15:59:46 CDT 2014
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 >