Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

steve728

Programmer
Mar 16, 2003
536
US
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
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top