[AccessD] Creating default false in yes/no field

Rocky Smolin rockysmolin at bchacc.com
Thu Jul 31 12:47:05 CDT 2014


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



More information about the AccessD mailing list