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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

search form without changes in my tabel 1
Convert Text to Numeric 2
e-mail access 2003 4
Excel How to get the number of days an item was opened from the today's date. 14
Combo box default 2
User Sets Control Default Value 1
Pivot table - Change default summarise value field. 2
Custom date format creates visible default value? 1

Back
Top