Access Tables

E

Ed Wyche

When inside the table if I start numbers in a field and then arrow down to
the next record put another sequential number and I arrown down it
automatically puts the next number in. Is there away of stopping that.

Example
1
2
3 is automatically put in
4 is automatically put in
 
J

John Vinson

Why do I think you are putting number in an Excel Spreadsheet not number
in a Access database table???
Click to expand...

Because it's behaving like Excel. Reasonable supposition but...
Access should not be doing it that way. It does have autonumbers but
they don't act exactly like that.
Click to expand...

We all agree with you, Joseph - however, since A2000 came out, this
inappropriate behaviour has been happening in Access as well. Somebody
at Microsoft thought (wrongly!) that "it would be helpful". It's a
misfeature, and quite a few MVP's have yelled loud and clear to the
Access development group about it. It's still in 2003 though.

John W. Vinson[MVP]
 
J

John Vinson

When inside the table if I start numbers in a field and then arrow down to
the next record put another sequential number and I arrown down it
automatically puts the next number in. Is there away of stopping that.

Example
1
2
3 is automatically put in
4 is automatically put in
Click to expand...

This is a misfeature introduced with A2000. You're right, it should
not be happening. Unfortunately there is no way to turn it off *in
datasheets*.

The solution is to create a Form (preferably a Continuous Form made to
look like a datasheet, if you like that view). It happens in
datasheets but *not* in such forms. This is just one of many reasons
to use Forms for data entry rather than directly updating tables.

John W. Vinson[MVP]
 
Top