By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,399 Members | 960 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,399 IT Pros & Developers. It's quick & easy.

Auto numbering in spreadsheet view

P: 1
I would like to know how to turn off the auto number feature when entering data
in the spreadsheet view of an access form. When I enter a number in one record the next record automatically adds the next number in a sequence. I need to trun this feature off. Help!
Nov 30 '06 #1
Share this Question
Share on Google+
3 Replies


blyxx86
100+
P: 256
I would like to know how to turn off the auto number feature when entering data
in the spreadsheet view of an access form. When I enter a number in one record the next record automatically adds the next number in a sequence. I need to trun this feature off. Help!
View the table in design mode (right click on the table in the main menu) and select design view, then change the type from autonumber to whatever you'd like.
Nov 30 '06 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
View the table in design mode (right click on the table in the main menu) and select design view, then change the type from autonumber to whatever you'd like.
Good suggestion.

But it won't actually let you change from an autonumber. You have to add a new field and set it to data type number. Then copy accross all the values currently in the autonumber field.

Then delete the autonumber field. Don't forget to rename the new field to the same name as the deleted field.

There are other implications to this as you will have to add this number for all new records added to maintain integrity.
Dec 1 '06 #3

NeoPa
Expert Mod 15k+
P: 31,661
Or, if the field is of no further use, just delete it and save yourself a lot of hassle :).
Dec 1 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.