|
| 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
January 26th, 2005, 06:45 AM
|
|||
|
|||
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
January 26th, 2005, 07:29 AM
|
|||
|
|||
|
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
January 27th, 2005, 06:50 AM
|
|||
|
|||
|
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 |
Linear Mode
