Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


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

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.

 

 

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