Andy Lacey
andy at minstersystems.co.uk
Wed Aug 17 08:17:12 CDT 2005
IIRC it shows tick if -1 and no tick (ie False) if anything else, or vice-versa. I don't think it'd cause this, though like you I haven't tested. And Susan's right. If the value is Null it shows a grey tick box but allows you to tick/untick. -- Andy Lacey http://www.minstersystems.co.uk --------- Original Message -------- From: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Subject: RE: [AccessD] checkboxes aren't functioning Date: 17/08/05 12:54 However what if it is bound to a non-boolean field. For example it is bound to an integer, the integer can contain 0 and -1 (and null) so it looks like it works just fine. But what happens if the field gets set to something other than null, 0 or -1? Note I have never tested this, just throwing it out.... John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/ -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins Sent: Wednesday, August 17, 2005 8:44 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] checkboxes aren't functioning Checkboxes have a tri-state, on, off, and Null. You might want to check that -- perhaps someone accidentally changed it? Although, if I'm not mistaken, even if the control is Null, you should still be able to change it. Susan H. how is it possible that suddenly on a form in almost al records certain checkboxes are working but in some records they don't function (are greyed out and can't make them "true" or "not true"). Nothing strange happened before. -- 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 ________________________________________________ Message sent using UebiMiau 2.7.2