my null defaults being changed to zero value?

[cormier35 via AccessMonster.com]

I have a simple form where I set some entries default to Null. When I enter
other values in the table the null defaults becomes a zero value? I'd like to
keep null entries as nulls.

 

[Banana]

In Access 2003 and earlier (Not sure about 2007), any number fields you
create always has a default of zero. If you want it to default to null,
you need to go into table design for where you have those number fields
and delete the zero from the default property.

 

[Jack Leach]

Allen has written a function that I use without fail every time I make a
table to turn this "feature" off.

http://allenbrowne.com/bug-09.html


--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)

 

[Stuart McCall]

Allen has written a function that I use without fail every time I make a
table to turn this "feature" off.

Funny how things come around. In the A2.0 days, I wrote a function to do the
exact opposite!

 

[Jack Leach]

I suppose the million dollar question is: do you still?? <g>

--
Jack Leach
www.tristatemachine.com

"I haven't failed, I've found ten thousand ways that don't work."
-Thomas Edison (1847-1931)