Boolean Values

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   How can I set the form field's value if it is a checkbox?

I am loading values from an access database and the field values in the Access table are boolean.

Calling 
QP.SetFormFieldValueByTitle("Error_Correction." + RecNo.ToString, ds_Binding.Tables(0).Rows(RecNo).Item("Error_Correction").ToString)

or

QP.SetFormFieldValueByTitle("Error_Correction." + RecNo.ToString, ds_Binding.Tables(0).Rows(RecNo).Item("Error_Correction"))

The checkbox does not appear in the form field if the Error_Correction field value of the Access table is set to "True" nor if it is set to "Yes"

I am using VB.Net 2005.  Everything else works fine.  I have no problems with text or date fields.

Thanks in advance for your assistance.

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
unified Members Profile Find Members Posts Beginner Joined: 04 Dec 05 Status: Offline Points: 11	Post Options Post Reply Quote unified Report Post Thanks(0) Quote Reply Topic: Boolean Values Posted: 02 Oct 07 at 3:48AM
	How can I set the form field's value if it is a checkbox? I am loading values from an access database and the field values in the Access table are boolean. Calling QP.SetFormFieldValueByTitle("Error_Correction." + RecNo.ToString, ds_Binding.Tables(0).Rows(RecNo).Item("Error_Correction").ToString) or QP.SetFormFieldValueByTitle("Error_Correction." + RecNo.ToString, ds_Binding.Tables(0).Rows(RecNo).Item("Error_Correction")) The checkbox does not appear in the form field if the Error_Correction field value of the Access table is set to "True" nor if it is set to "Yes" I am using VB.Net 2005. Everything else works fine. I have no problems with text or date fields. Thanks in advance for your assistance.

unified Members Profile Find Members Posts Beginner Joined: 04 Dec 05 Status: Offline Points: 11	Post Options Post Reply Quote unified Report Post Thanks(0) Quote Reply Posted: 02 Oct 07 at 4:08AM
	Solved. The export value of the checkbox field on the form should be set to "True" rather than "Yes" in order for this to work.