Hi, we recently upgraded from MS Access to MS SQL Server.

Adding new records to one table is now creating 2 fields with a value of zero even though i have set the default value to NULL in the grid, the default value is NULL in the DB, made sure the field allows NULL values and i have ticked Blank is NULL for the fields.

All other fields that initially had the same problem are now ok once I ticked Blank is NULL.

One field is an INT type and the other is nvarchar(255)

Can't for the life of me work out why, any help appreciated