Jeremy Boschen pointed out an easy way to load a Boolean into a check-box control in the tip, “Use Boolean Variables for Check-Box Values” [101 Tech Tips for VB Developers, Supplement to the February 1998 issue of VBPJ, page 1]. Conversely, you might want to put the value of the check box into a database as a number. To do so, use this code:
!db_field = Abs(Check1.Value = vbChecked)
This puts 1 into your database field. To make the value -1, change the Abs in the line to CInt. For VB3, you can’t use the constant vbChecked and must use the value 1.