Hi cc30729,
Jeremy is right - do not try this at home. This is an often asked question and the 'requirement' almost always stems from a misunderstanding about what autonumbers are. If you really, really, really do have a solid reason then Jane's method is the one to use.
Zameer,
Your method only changes the way the number is displayed; it does NOT change the actual autonumber so if it is used as data anywhere its value is still, for example, 1, not 40001.
The format of "\40000" simply displays a 4 followed by the number using a minimum of 4 digits (the four zeroes), so ..
[tt]
1 displays as 40001
2 displays as 40002
:
:
9998 displays as 49998
9999 displays as 49999
10000 displays as 410000[/tt]
Enjoy,
Tony
------------------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading FAQ222-2244 before you ask a question.