Zeros Showing in Form Field

  • Thread starter Thread starter ADB_Seeker
  • Start date Start date
A

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
 
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.
 
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
Click to expand...

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!
 
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
 
Back
Top