1 Reply Latest reply on Jul 11, 2008 10:29 AM by (Jeff_Strahl)

    Checkboxes not inserting correct values into database

      Hello,
      Excuse me if this has been posted before, I have tried finding a similar problem to no avail.

      I have been setting up a Add Record form using the appropriate 'Insert Record Form Wizard'. All in all it's working, however, checkboxes are giving me grief.

      I have set the values to 0,1. When the checkbox is not checked, the value inserted is NULL or empty, when checked, the value inserted is 0. Since I am building this application off an existing database, I am limited as to where I can be flexible for false values are already set to 0.

      I appreciate any assistance.