InfoPath Dev

I'm trying to get the check boxes to display Yes or NO when I submit the result to the SharePoint Library. In the SharePoint Library they display True and False.

Take the Check box type as Text(string) then select its properties and change them to Yes when checked and NO when cleared.

Hope this helps you.

I'll try it. But I don't know if Info path accepts text(string)

Can you use a char instead?

text(string) is the default datatype for most controls

if you add a check box it's default datatype is boolean but you can change it to string from it's properties as shekar said

an sql char field will be handled as a string in infopath yes

Text data type will not work..my format selections become grayed out

Does anyone know how I would diplay Yes or No for Infopath and tranfer that to SharePoint Form Library Column?

You have to bind the check box to a text(string) field, then you can change the properies to say what you want.

If the field is a bit field from a database then you have to change the field to varchar in the database and redo your connection

Check boxes do not have a format button

or you could create a dummy field then set rules on the check box to change the dummy field to what you want to display, then promote the dummy field to sharepoint instead