Hi all,
I'm STUMPED. In Access, I have a series of checkboxes on a form. I know that the checked value can be "true", "on", or "yes", and the unchecked value is "false", "off", or "no". But when using mySql Front to upload the data to mySQL database, ALL OF THE INFORMATION IN THE CHECKBOXES IS LOST. The values, regardless of whether the box was set to checked or not, show up as zero. I have read that mySQL cannot interpret boolean data, but I don't know what that means. Can someone please tell me:
WHAT do I set the table to in mySQL to be able to accept the value of the checkbox?
WHAT do I set the checkboxes to in Access when editing the properties of the fields in the table?
Please email me at the above address, removing the "NOSPAM", or reply here. If you can assist me I'll be forever grateful!
Thank you!
Autumn
