Blank Default

R

RAB

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?
 
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.
 
Top