John Bartow
john at winhaven.net
Tue Jun 10 13:54:15 CDT 2003
The default value wasn't set. I set it to Null and now it works. Manually set a value to null, that's odd isn't it? Thanks! JB > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Charlotte > Foust > Sent: Tuesday, June 10, 2003 1:31 PM > To: accessd at databaseadvisors.com > Subject: RE: [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 > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >