If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Autonumber
Hi
I want to add an Autonumber field to a table and its form. I want the format of it to be six digits no matter what the number (ie - 000001,000002). Is this possible? Thanks Dave |
#2
|
|||
|
|||
Just set the Format property of the field to:
000000 -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Stig" wrote in message ... Hi I want to add an Autonumber field to a table and its form. I want the format of it to be six digits no matter what the number (ie - 000001,000002). Is this possible? Thanks Dave |
#3
|
|||
|
|||
Thankyou Allen
Dave "Allen Browne" wrote in message ... Just set the Format property of the field to: 000000 -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Stig" wrote in message ... Hi I want to add an Autonumber field to a table and its form. I want the format of it to be six digits no matter what the number (ie - 000001,000002). Is this possible? Thanks Dave |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
insert and autonumber | TheSniipe | Running & Setting Up Queries | 1 | December 6th, 2004 11:39 PM |
Problem with AutoNumber | accessmonk | Database Design | 2 | September 30th, 2004 08:57 PM |
keeping track of "Escaped" Autonumber records | Paul James | Using Forms | 7 | September 28th, 2004 12:06 AM |
Autonumber | Ally H. | General Discussion | 7 | August 27th, 2004 04:51 PM |
autonumber | Deepak | General Discussion | 3 | June 18th, 2004 09:07 PM |