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

Charlotte Foust charlotte.foust at gmail.com
Mon Dec 13 13:24:27 CST 2010


Use either True/False or Yes/No.  Using -1 or 0 will cause you
problems if you need to work with a SQL backend at some point, since
SQL Server uses 1/0 for True/False values.

Charlotte Foust

On Mon, Dec 13, 2010 at 9:27 AM, Dan Waters <df.waters at comcast.net> 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