Fw: [AccessD] Triple State Check Box

Hi Børge

Seems OK to me.

You could have chosen Byte but then you would need to record Null, 0,
and 1.
1 is valid for not False in VB(A) and you can check for that with 

  <> False 

or 

  Not False

Validation rule could be: 0 Or -1 Or Is Null 
or, for Byte: 0 Or 1 Or Is Null

/gustav

>>> pcs at azizaz.com 22-11-2004 14:22:25 >>>
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