InfoPath Dev

A bit is a 0 or 1. You have tried a boolean field with both true or false or 1 or 0 as the default?  I cannot find anything specific on using bit fields with InfoPath but it may not work since it is a specialized data field. I think you would need to change it in SQL to a char or int instead of a bit. I would think a conversion to an int ...

The column type in SQL is bit. When I turned the checkbox to TextBox, it is receiving True/False from database.    (with the first letter as capital)

I would change your checkboxes to text boxes and verify your values coming in from SQL.  Are they 0 and 1 or what?  Then makes sure you go into the check box properties and set the correct values for checked and unchecked. What is the column type in SQL?

When I have changed the checkbox data type to text(string) it looks working, but it is not showing the checkbox as checked when it gets 'true'  value from the database. Also it is raising an exception when I am trying to submit the form to sharepoint server. The error is Server was unable to read request ---> There is an error in ...

Hey Ed. The Email submit is set and cannot be edited by the user. They can only send or cancel. Two options. 1. You can allow the Send To: command from the file menu but this just emails the current view. 2. Add the fields in your form itself, or create another view where they can update the fields before the email and then have the submit ...

You may want to convert from whole number to text and then switch your checkboxes to text boxes and verify what you are receiving from SQL. You can have them as text boxes in InfoPath and still use 0 or 1 or whatever the value is for your checkbox.  

I have a form that is being tested by users, I supplied them with a button to email the form. When they click the button to email, the form that opens with the To: Subject: CC: are all grayed out. They would like to have the ablity to add a name to CC to and to be able to change or add to the subject line....How can I do this... Thanks

I did exactly the same way you said above, now it is giving me error:  Only intergers are allowed. When I changed the values of checkbox as when cleared: 0 and when Selected : 1 (In the checkbox properties), it is giving me error: Only 0 or 1 allowed. so, does it mean that, Infopath is receiving data from sql server in some other format? ...

My guess is tha this is a permissions issue with the server. It should have nothing to do with the form.

updated an existing template with some new fields and data connections.  now users are unable to open any of the older forms they had saved.  before the current update users were able to open all the forms with ie.  i can open the old forms but only using infopath and not ie.   Error: There has been an error while ...