Resetting value in boolean drop-down

[SDP]

Hello. I have some drop-down boxes - YES or NO can be selected.
I am unable to change the Drop-Down List Box Properties' value from "True"
to "Y". (My requirement is that these values be "Y" or "N".)

I submit the form to an Access database (primary source), where I have
designed these particular fields to be of the data type: "Yes/No" and the
format: "Yes/No"
Should I just change these Access data types to a text type? That wouldn't
be consistent with the schema, but it would allow a "Y" or "N".

Any idea how I can change the value in the InfoPath form? Right now, the
Access table has a check box, and it's either checked or unchecked after form
submission. The value of these check boxes after exporting to XML are "0" or
"1", not the "Y" or"N" that is required.

 

[Josiah Smith]

Make the datatype in your infopath form as a string data type, and set the
value for 'checked' to 'Y' or 'Yes', and the value for 'unchecked' to 'N' or
'No.' this will still work in the form logically as a boolean value in that
it will be one of two variablse, only instead of 'TRUE' and 'FALSE,' those
variablse will be your designated variables. Don't forget to set the default
value to 'No,' or 'Yes,' as that may have unknown effects upon your database
if a user decides not to change a field.

HTH,
Josiah