View Single Post
 
Old May 22nd, 2006, 09:35 AM
SerranoG SerranoG is offline
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

Actually, if you do not specify a default field value when you create a table and you do not specify a default field value in the form based on the table, then an integer field is NOT initialized to zero. It's null.

An integer VARIABLE created in VBA may be initialized to zero automatically upon runtime of the VBA code, but not a field in the table.

I just tested it. I created a table, added an integer field, took away the default value setting, and left it blank. When I started entering data, the default integer value was null.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division