[AccessD] (Yes/No) field - no state A97

Check the field's default value.  It is probably set to 0/False.  If you
want to use triple-state, you'll need to set the default to Null.

Charlotte Foust

-----Original Message-----
From: John Bartow [mailto:john at winhaven.net] 
Sent: Tuesday, June 10, 2003 10:26 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] (Yes/No) field - no state A97


Thanks Doris,

So triple state is a display feature. Mine is not working :o)

Going beyond that, I guess what's throwing me is that when I look in a
table where the Yes/No should be null it is always false. How can I get
it to remain null until it has a value?

JB

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Mike and 
> Doris Manning
> Sent: Tuesday, June 10, 2003 12:41 PM
> To: accessd at databaseadvisors.com
> Subject: RE: [AccessD] (Yes/No) field - no state A97
>
>
> TripleState basically controls how a checkbox appears on a form or 
> report. If the underlying value is True, then the box is checked.  If 
> False, then the box is not checked.  If Null, then the box is gray.
>
> Having the final report evaluate nulls is probably your best bet and 
> is cleaner than going the TripleState route when you want the nulls to

> display a particular text.
>
> Doris Manning
> Database Administrator
> Hargrove Inc.
> www.hargroveinc.com
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Bartow
> Sent: Tuesday, June 10, 2003 1:19 PM
> To: AccessD
> Subject: [AccessD] (Yes/No) field - no state A97
>
>
> I've seen some discussion on this throughout the ages but I've never 
> paid attention to it since it would only seem to be needed when a 
> design is flawed.
>
> But...
>
> I have a project which is almost complete that uses a number of Yes/No

> fields and the client just informed me that there is a condition where

> neither would be correct.
>
> The form is part of an evaluation of conditions. The conditions can 
> only be yes or no but, in the endless glory of government programs, if

> a partial evaluation had been done before the latest standards the 
> evaluation can be completed with a "Not Evaluated" given to certain 
> areas.
>
> I thought maybe I could just have the final report evaluate nulls in 
> the Yes/No field as "Not Evaluated" areas. The "Triple State" isn't 
> making much sense to me. Can anyone clear it up for me or should I 
> just change my last minute change approach and add a new field?
>
> John B.
> PS: There isn't any additional money to be had so either I do it 
> easily or I eat the expense. Even though it was explained to me that 
> it could only be yes or no, it isn't explicitly stated anywhere in the

> specs and the contact
> person is gone now, so...
>
>
> _______________________________________________
> 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