Mike and Doris Manning
mikedorism at ntelos.net
Tue Jun 10 12:41:30 CDT 2003
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