Blank Default

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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.
 
Back
Top