View Single Post
 
Old May 19th, 2006, 09:18 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

As long as the table does not require a value to be input for the record, you should be able to set the integer to null (even if the default is zero) simply by doing something like this for the textbox that is bound to the field.

Me.txtInteger = Null

I assume you can do this because what if there truly is no value for that record? A zero is misleading because you think that the actual value is zero when the value is really "nothing was ever entered."


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