[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
>