Zeros Showing in Form Field

[ADB_Seeker]

I have currency and number fields on my form that are showing zeros.
I removed the zeros from the Default Value in the Table.
The Default Value for each field on the form is empty.
The zeros are still showing.
I appreciate all help provided.
Linda

 

[ghetto_banjo]

Are they showing zeros on new records? Or just on the old records?
Previously saved records may still be holding those zeros in the table.

 

[John W. Vinson]

I have currency and number fields on my form that are showing zeros.
I removed the zeros from the Default Value in the Table.
The Default Value for each field on the form is empty.
The zeros are still showing.
I appreciate all help provided.
Linda

The default value only applies to *newly created* records. If you created
records previously, while the default was in effect, then there are actually
zeroes stored in the table.

You can run an Update Query updating records to Null if the field is currently
equal to zero, if that's what you want to do - just be sure not to null out
any values that are legitimately equal to zero!

 

[ADB_Seeker]

They are showing on new records. Field is not defaulting to zero.

 

[ADB_Seeker]

John & ghetto_banjo, you were correct. I did have a previous record on the
screen. A new record shows no zeros. Thank you for your quick replies!
Linda