Entering numbers in column, how to turn off auto sequencing?

[Guest]

When entering data in a query or table, the column is a number field. If I
enter "1" in a row, the "2" in the next row, "3" will automatically populate
the next row down. Similarly, "1", then "3", will populate "5" in the next
row down. Is there a way to turn this automatic populating characterist off?

 

[Joseph Meehan]

When entering data in a query or table, the column is a number field.
If I enter "1" in a row, the "2" in the next row, "3" will
automatically populate the next row down. Similarly, "1", then "3",
will populate "5" in the next row down. Is there a way to turn this
automatic populating characterist off?

Don't use a Table for data entry. I suggest a form or maybe a query.
Consider tables as just a place to store data, like a bucket.

BTW there is no way to turn it off other than just using the tools
designed for data entry.

 

[Guest]

Irritating isn't it. Go to Tools, Options, Spelling tab and click on the
AutoCorrect Options button. Remove all options.

Note: This isn't the same as Name AutoCorrect which is an entirely different
irritant.

 

[Guest]

This auto-sequencing characteristic is inherent whether done in a table or a
query. My function isn't data-entry for a single record at a time. It is
engineering work and tables are filled in by some data entered here and there
as it is available. The table or query view seems to work best. I might
could create a form that looked like a spreadsheet, but it would be more
cumbersome to rearrange, multi-field data sorts, etc. Thanks for your
response!

 

[Guest]

I was really excited about your response ... but when I tried your
suggestion, the behavior didn't change. Thanks.

 

[Dirk Goldgar]

This auto-sequencing characteristic is inherent whether done in a
table or a query. My function isn't data-entry for a single record
at a time. It is engineering work and tables are filled in by some
data entered here and there as it is available. The table or query
view seems to work best. I might could create a form that looked
like a spreadsheet, but it would be more cumbersome to rearrange,
multi-field data sorts, etc. Thanks for your response!

Unfortunately, this is a built-in "feature" of datasheets, whether
they're table or query datasheets, and there is no way to turn it off.
Your only recourse is to use a continuous form instead, but you do lose
some of the handy features of datasheets.

 

[Guest]

Thanks, Dirk. I'm certain some clever effort was used to make this happen
automatically. A little too clever though if it can't be turned off. You're
response hit the nail on the head! Now I can finally stop trying to find a
fix!

 

[Dirk Goldgar]

Thanks, Dirk. I'm certain some clever effort was used to make this
happen automatically. A little too clever though if it can't be
turned off.

I don't know any Access developer who doesn't agree with you.

 

[Van T. Dinh]

Instead of using the DatasheetView of the Table / Query, create a basic Form
based on the Table / Query and then use the DatasheetView of the Form.
AFAIK, this will stop the "Auto-Fill" feature and the GUI is just like a
Datasheet you want.

 

[Dirk Goldgar]

Instead of using the DatasheetView of the Table / Query, create a
basic Form based on the Table / Query and then use the DatasheetView
of the Form. AFAIK, this will stop the "Auto-Fill" feature and the
GUI is just like a Datasheet you want.

Van, I think you're mistaken about this. It sounded like an exciting
possibility, but I just tested it and the form in datasheet view acted
just like a regular datasheet in filling in sequential values.

 

[Van T. Dinh]

Which Access version are you using Dirk?

I also tested before I posted my original reply (in A2003) and the Auto-Fill
didn't happen.

I simply created a simple Table with 3 Fields: Auto1, Long1 and Text1. Use
the Form Wizard to create a Form based directly on the Table, switched to
DatasheetView of the Form and the Auto-Fill stops on the TextBox bound to
Long1.

I am sure the DatasheetView of the Form behaves differently from the
DatasheetView of the Table / Query since on the DatasheetView of the Form,
the Form Events are stilled being exposed for us to use.

 

[Dirk Goldgar]

Which Access version are you using Dirk?
2002.

I also tested before I posted my original reply (in A2003) and the
Auto-Fill didn't happen.

I simply created a simple Table with 3 Fields: Auto1, Long1 and
Text1. Use the Form Wizard to create a Form based directly on the
Table, switched to DatasheetView of the Form and the Auto-Fill stops
on the TextBox bound to Long1.

I created a table with 2 fields: ID (autnumber, set as PK) and MyNum
(Long). I cleared the Default Value property of the MyNum field, which
Access had automatically set to 0.

Then I used the Form Wizard to create a datasheet form based on this
table. I opened that form and entered 1 for MyNum on the first row, 2
for MyNum on the second row. At that point, if I use the down-arrow key
to move to the next MyNum field in the next row, it automatically fills
in 3 for that row, 4 for the next, and so on.

I am sure the DatasheetView of the Form behaves differently from the
DatasheetView of the Table / Query since on the DatasheetView of the
Form, the Form Events are stilled being exposed for us to use.

Yes, this is true.

 

[Van T. Dinh]

In my case, I was tabbing through the 3 columns in the DatasheetView ...

Just tested again in A2003: I got the same Auto-Fill effect if I use the
down arrow. However, if I use the mouse instead of the down arrow, the
Auto-Fill doesn't happen on the 3rd and later rows.

It seems only the down arrow triggers the Auto-Fill but not tabbing or mouse
clicking. It may be of some use to the O.P.

--
HTH
Van T. Dinh
MVP (Access)



news:%[email protected]...