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.
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
