[AccessD] Creating default false in yes/no field

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



More information about the AccessD mailing list