Default Number value changed to 0 after I start to enter data into a form

[bell]

Hi all,

I have a form that has number entries. I changed the Default Value for these numbers to Null because I dont want 0s (they aren't being used for numeric calculations, they just hold a number). I want there to be nothing in the input field until I put it there.

My problem is, when I start to enter info into my form, access automatically places 0s into all my number entries! Is there a way to avoid this? Or should I just make the fields text instead?

Thanks

[June7]

Remove anything (0) in the field DefaultValue property in table. Then make sure textbox on form does not have anything in the DefaultValue property.

[bell]

Ohh ok I didn't realize the text box and the table entry had different DefaultValue properties, I thought the text box would inherit the property from the table entry

Thanks

[June7]

It will inherent when the control is first created. However, changing properties in table will not impact existing controls unless you tell it to at the time of the edit.