Autofilling value which is NOT autonumber

[da poet]

I have a table that keeps putting a zero value in the new recordl. It was previously an autonumber field. I changed that and deleted the zero from the default value property.

How do i get rid of this???

 

[neileg]

If the field is a number data type ( I think it must be), then the field will always show as zero when the field is null. I don't think you can change this. In a form, you can use Nz() to change the display to something else.