Does anyone know how to change a field FORMAT default? I am creating lots of tables with lots of number format fields. I don't, however, want a zero default value (or any default value for that matter) for all of these fields. I can go in and delete them manually, but that seems like a backward way of doing things. Does anyone know how to elimate that default value from the format of a number field in general?

Thanks!
Carly

Open the table in design view. Click on the field. Go to the bottom of the screen where you will find the DEFAULT VALUE.
If you wish the default value to be nothing, ensure the DEFAULT VALUE is nothing.
Hope this helps.

There is no place to control the default value. You could write a code loop, that runs through all numeric fields in your tabledefs collection and sets the default to null.