Can i start an autonumber with a fixed value ?

[Nokia N93]

In access can i start an auto number with a fixed value ?

ex:


i want the autonumbers to be 2011 then the autonumber
(2011001, 2011002, 2011003, ... )

[RuralGuy]

Here's a good article on AutoNumbers: http://www.utteraccess.com/forum/Aut...t-t443604.html

[pkstormy]

I would create an integer type field and manually control populating the value instead of trying to manipulate an autonumber type field. I would highly recommend NOT trying to change or force a value into an autonumber field. You can easily end up corrupting the table if you try to force a value into an autonumber field.

If need be, you can also create an expression in a query to combine the autonumber value with another field or the current year (ie. MyAutoNumber: [AutoNumberFieldName] & [SomeOtherFieldName] or MyAutoNumber: Format(Date(),"yyyy") & [AutoNumberFieldName])