Binding Y/N (Yes/No) database field to a Checkbox control

[Hersh]

I've bound a Y/N field coming from an Oracle database (via a Web Service) to
a Checkbox control. I'd like the Checkbox to be checked when the value of
this field is "Y" -- and not checked when its value is"N". How can I achieve
this behavior?

Thanks.

 

[S.Y.M. Wong-A-Ton]

Double-click on the checkbox to open its Properties dialog box. Change its
"Data type" to "Text (string)", type in "N" for "Value when cleared", and "Y"
for "Value when checked". If you cannot change the data type because it has
been locked by InfoPath and set on "True/False (boolean)", then you'll have
to let your web service return TRUE/FALSE or 1/0 instead of Y/N for the
checkbox to work.

 

[Hersh]

Thanks S.Y.M.!

Simply setting the "Value when cleared" and "Value when checked" properties
according to your instructions did the trick.