Check box on unbound form error

B

Bob

I have two check boxes that update a yes/no field in the rst field (using
DAO). If left unchecked on save they return a data conversion error 3421.
Any help would be greatly appreciated.
 
S

Stefan Hoffmann

hi Bob,
I have two check boxes that update a yes/no field in the rst field (using
DAO). If left unchecked on save they return a data conversion error 3421.
Any help would be greatly appreciated.
Click to expand...
Checkboxes have three states: True, False, Null. I assume you are
leaving it Null.

You may set the default value in the property editor or use the Nz()
function when updating your record, e.g. rst![Field] = Nz(chkBox.Value,
False).


mfG
--> stefan <--
 
Top