turn off auto fill in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I have several number fields in a row, when I move to the third number
field, a built in calculation is automatically made to continue a pattern.
Very annoying and possibly dangerous if I'm not paying attention. Example:
Field1 = 1, Field2 = 3, when I move to Field3 it auto fills 5. I want Access
to stop doing this.
 
I've never seen this.
What version of Access?
Is this happening at table level or in a fancy form that someone created?
Are you sure that this isn't Excel?
 
It's an annoying feature. You can either set a default for the field, or
use a form for data interaction.
 
Access 2000. Nothing fancy, datatasheet view. Excel doesn't do this unless
you ask it to. This is totally automatic. If you want to see it work, start a
new table in Datasheet view (rather than design view). Type a 2, tab, 4, tab.
You will automatically get a 6 in the next column. It is limited. It doesn't
work if I type a 5, then a 10, it doesn't give 15 (stays blank). It seems to
require and addition magnitude of 1 or 2. 3, 5 will give 7. 8, 9 will give
10. I ran into it when moving around in a table where multiple fields stored
values of 0-3. I didn't even have to type new values: if I moved from a
column with a 2 to a column with a 3 AND THEN the next column was BLANK, it
produced a 4.
 
OK, I lied about not having to type. You don't have to type the first number
(it can already be there), but you have to type the second to get the third.
 
Back
Top