Changing auto ID numbers

G

Guest

H...E...L...P

I am trying to change the auto ID numbers in the data base, thats Customer
ID and Product ID to a manual system. I don't want to use sequential numbers.
Does anyone know if this is possible and how we remove the auto formatting
for these areas?

I am lost.
Alan
 
A

Allen Browne

If you want to permanently change the AutoNumber field into one where you
can type a number:

1. Open the table in design view.

2. Change the Data Type column beside this field from:
AutoNumber
to
Number.

3. Remove the 0 default value in the lower pane of table design.

4. Save the table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Generate Primary Field Value 5
Auto Number ID Field 4
Data Entry Form and Auto Number ID 2
Auto Numbers 3
Changing the Autonumber value of already created records 6
How show table text, not auto id number 3
auto number in query 1
auto-numbering records in a sub-table 4

Top