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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hersh - 27 Apr 2007 16:14 GMT

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.

Reply to this Message

S.Y.M. Wong-A-Ton - 30 Apr 2007 07:38 GMT

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.
---
S.Y.M. Wong-A-Ton

> 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.

Reply to this Message

Hersh - 30 Apr 2007 14:44 GMT

Thanks S.Y.M.!

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

> 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"
[quoted text clipped - 11 lines]
> >
> > Thanks.

Reply to this Message

Rate this thread: