Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: Visual Basic
Expertise: Beginner
Jun 7, 1999



Building the Right Environment to Support AI, Machine Learning and Deep Learning

Put Your Check-Box Value Into Your Database

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.

Joe Karbowski
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date