Solved

CheckBox - How do I show my Three State checkbox to show the NULL state as a string value?

Posted on 2008-06-20
2
356 Views
Last Modified: 2011-10-03
I want to use a checkbox that informs the user that the NULL value is "Unknown". I know the code to show that "Yes" if the checkbox is true & "No" if false but how would I code the NULL value in my table to show "Unknown"? Is this possible? I am using a Visual Basic form and SQL database. The datatype is set to a BIT.
Private Sub LicenceAgreeCheckBox_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CheckBox.CheckedChanged

        If CheckBox.Checked = True Then

            CheckBox.Text = "Yes"

        Else

            CheckBox.Text = "No"

        End If

    End Sub

Open in new window

0
Comment
Question by:teustace
2 Comments
 
LVL 18

Accepted Solution

by:
jcoehoorn earned 50 total points
Comment Utility
Use the CheckState property:
Private Sub LicenceAgreeCheckBox_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CheckBox.CheckedChanged

    Select Case CheckBox.CheckState

        Case CheckState.Checked

            CheckBox.Checked = "True"

        Case CheckState.Indeterminate

            CheckBox.Checked = "Unknown"

        Case CheckState.Unchecked

            CheckBox.Checked = "False"

    End Select

End Sub

Open in new window

0
 

Author Closing Comment

by:teustace
Comment Utility
Hi Jcoehoorn, Many thanks! Works a treat and I can use this for other things....
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Introduction Although it is an old technology, serial ports are still being used by many hardware manufacturers. If you develop applications in C#, Microsoft .NET framework has SerialPort class to communicate with the serial ports.  I needed to…
Introduction Hi all and welcome to my first article on Experts Exchange. A while ago, someone asked me if i could do some tutorials on object oriented programming. I decided to do them on C#. Now you may ask me, why's that? Well, one of the re…
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now