How come zeros keep popping into my number fields?

[RSW]

On my form I have several fields that relate back to Number columns through a query. There is no default value set for them. The fields are blank when a new record is pulled up; however, zeroes pop in for some reason once I begin entering data. For example, if I type a 1 into a blank field, a zero appears to make it "10".

Does anyone know why this is happening and how I can fix it?


Thanks in advance.

 

[RSW]

Note: For some reason the fields now show as zeroes...even though I do not have any default set! And it is a pain to have to highlight each zero, then type over it with the desired number.

Help?

 

[missinglinq]

Have you actually deleted the Default Value for these fields? When you create a numeric field in Table Design View, Access automatically enters a zero as the Default Value for the field. You have to go in and delete this otherwise it will show up, and yes, it is a pain n the neck!

 

[RSW]

Ohhh...There was no default value in the form, but there were zeroes as the default in the table! I didn't realize the default zeros would have been set (and didn't realize I couldn't see them from the form). Thanks!!

 

[missinglinq]

It's a nasty habit of Access, setting this as the default default, as it were! I've seen people setting up validation code to be executed when a field is Null, and wondering why the code isn't run when the user hasn't entered any number; the reason, of course, is a numeric field with a zero in it isn't Null.