Random 0 now

[Mounds]

I have had my Access database running for 3 pr 4 years now with out much trouble. It was decided at work that it was a needed tool and they asked me to add a few queries and forms for some other users to make their jobs easier and make it easier for them to navigate Access. I made my changes and everything works great. But I did create one problem, for some unknown reason whenever a new entry is made a 0 is entered in one of my fields. Its a text field and its confusing to me. Its just a field in one of my tables. Its only tied to one querry in which I set criteria "IsNull" However I have deleted this query and it still is there. I've also check properties and there is no default value set.

[RuralGuy]

Both tables and forms have Default values.

[Mounds]

Didn't even think to check the form. Thanks for the head check problem solved.

[RuralGuy]

Excellent! Go ahead and use the Thread Tools and mark this thread as Solved.

[Mounds]

Thanks, I was wondering how that gets done. This place is great.