Fw: [AccessD] Triple State Check Box

Any one who wants to offer a comment?
Borge

----- Original Message ----- 
From: "Borge Hansen" <pcs at azizaz.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Saturday, November 20, 2004 9:44 AM
Subject: Re: [AccessD] Triple State Check Box


> Hi,
> I've been playing around with the triple state property of a checkbox on a
> bound multirecord subform bound to a Yes/No field in the backend table.
>
> To make it work I finally had to bind the check box control to a field
with
> a different datatype.
> It's now bound to an integer field
> with default value of 'null'
> and validation rule set to: 'Between -1 And 0 Or Is Null' .
>
> Now it works.
>
> But : Is that the (only) way to do it, or have I overlooked something?
>
> Regards
> Borge



---
Outgoing mail is certified Virus Free by AVG Anti Virus System.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.773 / Virus Database: 520 - Release Date: 5/10/2004