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. 

hi Bob,

Bob wrote:
> 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. 
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 <--