• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 881
  • Last Modified:

Auto sequence in a table

How do I stop Access from auto filling the next record if it spots a sequence?

eg. In a text field if it put the following records in 1,2,3 it will automatically put a 4 in the next record.

I understand I can stop this if adding to a form but I can't figure out how to stop it when adding directly to the table.

1 Solution
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You can't stop it when adding data directly to a table. More importantly, your users should NEVER be adding data directly to a table.
I take it this is a autonumber field? if so then this is how Access works. Once u create a new record, it automatically gets the next available number and assigns it to you.

What is the exact issue though, why would u want to stop it?

Is it the sequence u are worried about? u can generate random numbers
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
rocki: I don't think this is an autonumber field, but is instead a standard Numeric or Text field ... if you fill in the first record with 1, the second with 2, then Access will automatically insert a 3 in the third, and a 4 in the fourth, and so on ...
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

oh, I know what u mean now, durr!!!! having a thick idiot moment there :)
yes, Ive seen that, Ive not seen anything round that, nothing in autocorrect that ive seen either
sbiddleAuthor Commented:
It's just a normal text field.  Also happens on a form set to datasheet.  Thought if I could control it on the table itself that would be the best place to start.  Setting the default for the field to Null seems to work but it's not really what I want.

I thought maybe I was missing a setting somewhere as most things can be controlled - but not this it seems!
What version of Access?
Jeffrey CoachmanMIS LiasonCommented:

In the Table, put an Input mask of:

This will allow up to a three digit number and disable the auto-sequence.

For larger numbers, simply increase the mask:


Use a sequence other than 1,2,3,4  or 2,4,6,8

Instead, try to use a sequence of 10's (Typing 10 then 20 WILL NOT produce a 30 in the next row)
(A sequence of 3's or 5's WILL NOT auto-sequence either.

Jeffrey Coachman
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now