Checkbox fields automatically set as required fields. Cannot chang

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeffro - 28 Aug 2006 18:15 GMT

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.

Reply to this Message

S.Y.M. Wong-A-Ton - 30 Aug 2006 09:39 GMT

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

> Hi,
> Created a form with a connection to send results to a M.S. Access database
[quoted text clipped - 5 lines]
>
> I do not have any fields defined as required in the Access Database.

Reply to this Message

Rate this thread: