Access .mdb and vb6 for yes/no value

[pe]

I have an access 2000 mdb and a vb6 application that connects to it using ADO. I want to show the "postponed" field from my mdb in my vb6 form but it won't check or uncheck the checkbox according to the different records in the mdb. this is my code...

chkPostponed.Value = rsProj!Postponed

Also, i have an input form in vb6 that uses rsProj!Postponed = chkPostponed.Vlaue

Neither work. What am I missing? Thank you very much

 

[Sypher2]

You would probably need to use an If..then..else or Select case structure for this. The CheckBox control has 3 different values you can assign to it (unchecked, checked, greyed) not just a simple True/False that your Access database field would have.

If rsProj!Postponed = "True" Then
     chkPostponed.Value = vbChecked
Else
     chkPostponed.Value = vbUnchecked
End If

Hope that helps.

 

[Guest_imported]

Thank you very much. This did the trick!