How to stop numbers from being automatically entered in

  • Thread starter Thread starter Julie jeanson via AccessMonster.com
  • Start date Start date
J

Julie jeanson via AccessMonster.com

I often do data entry for in an access database for work, and any time I
enter a sequence, for example, 2 then 3 or 0 then 2, a number is
automatically entered in the next field. Most of the time it is NOT a
number I want, but I cannot for the life of me figure out how to stop
access from automatically entering these numbers. Please let me know how

Thanks!
 
I don't believe you can turn this "feature" off; it's an automatic "help"
tool that is built into ACCESS.
 
I often do data entry for in an access database for work, and any time I
enter a sequence, for example, 2 then 3 or 0 then 2, a number is
automatically entered in the next field. Most of the time it is NOT a
number I want, but I cannot for the life of me figure out how to stop
access from automatically entering these numbers. Please let me know how
Click to expand...

You can't turn it off in Datasheets - but you can base a continuous
Form on your table and do your data entry there. Such forms do not
have this misfeature.

John W. Vinson[MVP]
 
Back
Top