Auto number generation with specified format

[nishant.dhruve]

Hi is it possible to generate autonumber in calendar year form in Table
for example i want number to be generated something like this based on year

EU17/0000
EU17/0001
EU17/0002

and when year changes it should change automatic to

EU18/0000
EU18/0001


EU18/0002

if anyone can help me out on it i would greatly appreciate your efforts on helping me.
I have attached a sanpshot here. i would like this auto generated number to be plug in the table and it should create a new sequential number as we moved down to new record

[JoeM]

You do not have any control over what Autonumber gets set to. You CAN change the format of it, but not the value.
So you code "hard-code" the formatting to put "EU17/" in there, though it is NOT really part of the value, so you could not make it start over every year.
Really, all Auto number should be used for is to ensure a unique value.

If you have specific rules about some other ID field that you would like to work a certain way, you would probably need to control that with VBA.
Depending on how your data gets entered into your database (manually through Forms or via imports), would determine how you would run that VBA code (i.e. through the Load event on you Form or via an Update Query after a file import).

[RuralGuy]

Maybe this link will be useful: http://www.baldyweb.com/CustomAutonumber.htm