DefaultValue = 0

[Chuck]

At one time I entered a 0 as the default value of a field in a table. I
later wanted to change it, so that the default would be blank. It seems that
no matter what I do, even though the 0 has been deleted from the properties,
it still shows up as the default in forms and reports. How do I once and for
all delete the 0 default value?

 

[Duane Hookom]

You may need to check the Default Value property of your controls on your
forms.

 

[mnature]

If you set a default value, then that value is entered into the field as your
record is created. Once the record is created, changing the default value
only changes the value that will be entered into new records as they are
created. Any old records that had that default value entered do not see it
as a default value, but simply as a value. You have to go in and remove
those values if you no longer want them to be there.

 

[Chuck]

Thanks. That was what I needed.