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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
In many cases, I'm concerned with the existence of an amount, not so much
the value of the amount.
 
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
 
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!
 
No worries. We all need help and forget the obvious. That is why we have
this community. Glad I could help.


Randy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Currency field default 1
updated field 3
Suppress "0" in numeric text box 4
TransferText acExportDelim unexpectedly truncates numeric field 4
I don't want dollar sign with zeros in unfilled currenty field? 2
Zero fill numeric field 1
Why only one Current event for continuous forms? 9
Field that is not numeric 4

Back
Top