[AccessD] Creating default false in yes/no field

Ah, that makes more sense, Bill!  :)

Actually, Access evaluates any non-zero integer as True.  So I think it 
would work anyway with the option value of the two option buttons as 0 and 
anything else you fancy.

Regards
Steve

-----Original Message----- 
From: Bill Benson
Sent: Wednesday, August 6, 2014 2:15 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Creating default false in yes/no field

I just realize I had a typo (omission) which made me look pretty ignorant. 
What I meant to write to Steve was that I did not know one could make valid 
use of NEGATIVE option button values. Of course I knew one could assign 
values, but I thought they had to be 0-based. Heh Heh, dust off the old 
Dunce cap, eh?



From: Bill Benson [mailto:bensonforums at gmail.com]
Sent: Saturday, August 02, 2014 4:21 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Creating default false in yes/no field



Wow Steve, I did not know I could give option buttons values.. This is a 
useful trick you have given!

Very clever!

-Bill
On Aug 2, 2014 4:13 PM, "Steve Schapel" <steve at datamanagementsolutions.biz 
<mailto:steve at datamanagementsolutions.biz> > wrote:
>
> Bill
>
> You could have saved yourself a bit of trouble here by simply binding the 
> option group to the Yes/No field, and setting the Option Value of the 
> option buttons to -1 and 0.
>
> No hidden control, no code.
>
> Regards
> Steve
>

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com