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

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
> 



More information about the AccessD mailing list