Checkbox fields automatically set as required fields. Cannot chang

J

Jeffro

Hi,
Created a form with a connection to send results to a M.S. Access database
we have on our network. After setting up the connection, noticed that all the
fields in the Access database that were defined as Yes/No fields show up in
the Infopath Datasource as require fields. If I go to properties of the
these fields in the form, the required field check box is grayed out and I
cannot uncheck it. Any thoughts on whats causing this.

I do not have any fields defined as required in the Access Database.
 
S

S.Y.M. Wong-A-Ton

I think this is by design. Since InfoPath can connect to both MS Access and
SQL Server databases and yes/no (=boolean) fields in SQL Server can be only 0
or 1 (and not null), the same was used for both database types, making yes/no
fields required in MS Access. This is just my theory; I'm not part of the
InfoPath product team. :)
 
Top