G
Guest
I have a tabel with a numeric field that seems to want to make the default a
0. How can I make the default blank?
0. How can I make the default blank?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Ken Snell [MVP]
Open the table in design view. Click on the field. At the bottom of the
screen, you'll see a box next to Default Value. In that box is a zero.
Delete it so that the box is empty. Save and close the table. Now all new
records from this point on will start with a Null value in that field.
screen, you'll see a box next to Default Value. In that box is a zero.
Delete it so that the box is empty. Save and close the table. Now all new
records from this point on will start with a Null value in that field.