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