Hi Everyone,
I have a check box inside of one of the fields in an Access Database. How can I select that field through VB an know whether or not the check box has been selected or not? Thanks for any help.
Printable View
Hi Everyone,
I have a check box inside of one of the fields in an Access Database. How can I select that field through VB an know whether or not the check box has been selected or not? Thanks for any help.
VB Code:
If rs("CheckBoxFieldName") Then MsgBox "Selected"
If it's just a solitary check box you might like to consider putting it somewhere better like the registry.
If not, then just use ADO to retrive the value. If it's -1, then it's checked, otherwise it isn't. You might need to convert it using Abs() if you intend on putting the value into a checkbox on a VB form.