Default values are applied to new records in your table (they do not change
data in fields of pre-existing records). So just to clarify, when you go to
add a new record the field is empty even though in design view of this table
you have set the default value to 0?