Numeric field defaults to zero - I don't like that

[Guest]

I'm collecting dollar amounts (type Currency) in numeric fields. When a new
record starts, I get a default value of "$0.00"

I changed the control's "Default" property to "=NULL", but it still defaults
to "$0.00"

How do I get a numeric field to default to NULL?

Thanks.

 

[Guest]

In many cases, I'm concerned with the existence of an amount, not so much
the value of the amount.

 

[Guest]

Go to the underlying table. Select the field. Make sure the Default Value is
empty. Do not place =Null or anything else, just leave it empty.

Let me know if this helped.

Randy

 

[Guest]

Oh that hurts. Yes, there was a zero in there.

Not only did I assume it was empty to begin with, I assumed the control's
default would override whatever the table defined - so I never checked!

 

[Guest]

No worries. We all need help and forget the obvious. That is why we have
this community. Glad I could help.


Randy