Any table property tol auto fill numbers to Zero when adding re?

[steve728]

When adding a new record to a table, is there any kind of a table property that automatically fills in number type fields with a zero. I'm having to write code to fill in null values with a zero.

Thanks,

Steve

 

[LittleSmudge]

Yes,


In the table design you set the Data type to Number, Set the Field Size to Integer, or double , or whatever you need and you set the Default Value to 0 ( zero )

The first two you must have already done.
It's just the third that you need.


'ope-that-'elps.



G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.