Charlotte Foust
cfoust at infostatsystems.com
Tue Jun 10 13:30:42 CDT 2003
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