I have to create a program in Delphi using Access 2003 .mdb file as data repository.

The Access database has a table with a boolean (Yes/No in Access) field called "original".

I have mapped this field to a TDBCheckBox which shows checked for true and unchecked for false, and shows a half greyed check is the field has not been set.

What I want is oncreation of the field for the field to be set to false (checkbox unchecked) and save the field value as false **IF** the user has not explicitly set the field.

I have tried if (DVDQuery.FieldByName('Original').AsBoolean <> True) and (DVDQuery.FieldByName('Original').AsBoolean <> False )
 then DVDQuery.FieldByName('Original').AsBoolean := False;

But this does not work for new records. I use a query to access the dataset as there a large number of dynamically created where statements to filter the dataset.

ANy help guidance is greatly appreciated.

Rob