Rocky Smolin
rockysmolin at bchacc.com
Fri Aug 1 13:13:03 CDT 2014
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