When you are creating a new field and you want the default to be NULL, the query is getting passed through as ... default 'NULL' ... but since the quotes are around NULL, it is interpreted as the string NULL so the default becomes 0...maybe we could add a little checkbox for null, so it would be like Default ------- -- | | or | |null ------- -- what do you think? Dan Allen