Auto-Entering Zeros

  • Thread starter Thread starter Rick Johnston
  • Start date Start date
R

Rick Johnston

Hello,

Recently I tried to make some changes to the properties of some number
fields and the result is that Access is now auto-entering a zero in these
fields whereas before the fields were blank on entering a new record.

How do I change these back so that the fields will be blank on starting a
new record?

Thanks in advance for any help.

Rick
 
Hello there,

When you add a Number datatype to Access it adds a
Default value of 0. Go to the design view of your table
and select the field you want to change. Delete the
Default value 0 in the Properties section at the bottom.

Hope this helps

Judith
 
Rick,
I agree with Judith's response, but I would caution you about using Null
or Empty in numeric fields in general.
If there is any chance that you'll be adding, or even sorting those
numbers, it's best to leave the 0. Nulls will cause calculation and sort
failures later on.
I usually leave the default value for a numeric field as 0, but hide the
"display" of those 0s using formatting...
# ; # ; "" ; ""
so that 0s and Nulls just display blank.
hth
Al Camp
 
Back
Top