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.
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.