I have a checkbox where if it is checked, the value is "True" going to an Access 97 database.
Problem is, my table is not allowing any but the True value to be entered and will not update the database with a new recordset UNLESS the box is checked (and value would then be TRUE).
Here is my code:
Code:
<TD>Pref EZ/EC?</TD><td><INPUT TYPE='CHECKBOX' NAME='prefezec' VALUE='True'" & IIF(UCase(Value)="TRUE", " checked ", "") & "></TD>
Any way to fix this?