[AccessD] Yes/No Fields in Tables - Default Values?

Stuart McLachlan stuart at lexacorp.com.pg
Mon Dec 13 15:06:43 CST 2010


It doesn't matter.

 True/False and Yes/No as predefined numeric equated for the values -1 and 0.
Effectively they are all the same thing. 

-- 
Stuart

On 13 Dec 2010 at 11:27, Dan Waters wrote:

> I want to set my Yes/No fields to a default value to avoid the problem
> with a Null value.  If my Yes/No fields are bound to a control, it's
> always a checkbox.
> 
> 
> 
> Should I use True/False, Yes/No, or -1/0?  Or does it matter?
> 
> 
> 
> Thanks!
> 
> Dan
> 
> 
> 
> 
> 
> -- 
> 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