default value is null

[Guest]

I have a table with three fields and a couple hundred of records. I would
like to keep the "qty" field of a table blank until data is entered into it.
Is it possible and if so how do I do it.


Thanks

 

[Mark]

If the field is a number data type, go into the table design and look at the
"Default Value" property. It defaults to zero, but if you delete that, the
field will remain null until you enter something into it.

 

[Brendan Reynolds]

When you create a numeric field using the graphical table designer, Access
sets the Default Value property of the field to 0 (zero). Just delete that
zero from the Default Value property, leave the property empty, and the
default value will be Null.

You can also enter the world Null (without any quotes) in the Default Value
property, if you prefer. The effect is the same, but you may find the
meaning more clear.