Terence,
To make this as painless as possible, you should always compare the value of the field/expression to 0 rather than -1 or 1. Unchecked will always be 0.
Duane Hookom MVP
MS Access
________________________________
> From: buffalome000@yahoo.com
>
> This partucular db will eventually move to sql server. I realize the
> check box value is diff between server and desktop. I was attempting to
> make the desktop as compatable as possible "code wise". I realize that
> there are tricks like using "abs(x)" to obtain 0 and 1 values from the
> -1, I Really wanted to take as much pain of conversion away as
> possible.
>
>
> John Viescas <JohnV@msn.com> wrote:
>
> Terence-
>
> A normal check box control will have a value of 0 if unchecked and -1
> if checked. Why are you using the Wizard?
>
> John Viescas, Author
>
> buffalome000@yahoo.com
>
>
>
> Is it possible to build a check box with the control wizard which will
> act with a 0 for UNCHECK and 1 for Check ?
> I have tried several tim,es but the ctrl wizard always wants to have 2
> check boxs.
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (4) |
Tidak ada komentar:
Posting Komentar