Hi:

> On an update, it will go NULL. Defaults only apply to inserts and they are
> only set if the insert doesn't specify something in the column. Passing
> NULL in the insert statement will cause the column to be NULL. If you
> exclude the column from the Values() list in the insert, you will get the
> default.
>
> If you need the column to go to zero whenever it gets set null, you'll need
> a BU trigger to do that.

Anh! not the answer I wanted but oh well. Will keep the code setting it to '0'.

OnExit If('') then '0'. Oh well.

Thanks.

Best regards