SharePoint Integration

Re: Making check boxes display Yes or No

Stavi — Wed, 01 Nov 2006 16:16:10 GMT

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

Re: Making check boxes display Yes or No

Stavi — Wed, 01 Nov 2006 16:12:35 GMT

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

Re: Making check boxes display Yes or No

Michael71 — Wed, 01 Nov 2006 14:09:12 GMT

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

Re: Making check boxes display Yes or No

Michael71 — Tue, 31 Oct 2006 14:52:44 GMT

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

Re: Making check boxes display Yes or No

Stavi — Tue, 31 Oct 2006 14:50:00 GMT

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

Re: Making check boxes display Yes or No

Stavi — Tue, 31 Oct 2006 14:47:26 GMT

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

Re: Making check boxes display Yes or No

Michael71 — Tue, 31 Oct 2006 14:43:52 GMT

Can you use a char instead?

Re: Making check boxes display Yes or No

Michael71 — Tue, 31 Oct 2006 14:42:35 GMT

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

Re: Making check boxes display Yes or No

shekar — Tue, 31 Oct 2006 13:20:43 GMT

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.

Making check boxes display Yes or No

Michael71 — Tue, 31 Oct 2006 12:20:35 GMT

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.