Forum home » Delegate support and help forum » Microsoft Access Training and help » AutoNumber
|
|
|
The UK's most regular Training information:
See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
AutoNumber
Resolved · Low Priority · Version 2003
Reply Wed 18 Aug 2010, 15:11Delegate Alison said...
Alison has attended:
Access Introduction course
AutoNumber
How can I get autonumbers to be more than one digit long at the start eg 00001 not just 1?
For upcoming training course dates see: Pricing & availability
RE: AutoNumber
Hi Alison, thanks for your query. Select the autonumber field in design view and go down to the "Field Properties" panel. In the General tab click into Format and simply put "00000". Save the table and switch back to Datasheet view. Your first autonumber should now read "00001" and so on.
Hope this helps,
Anthony
|