Auto count in a text field

[Michael2767]

I need an auto counting text field on a form. I need it to count from 0001 to unlimited in a years time for the number of records created, then start over at 0001 when the years time has elapsed. Please help.

[ADezii]

Let's assume your AutoCount (TEXT) Field is named [AutoCount] and it is in a Table named tblTest.

1. Manually enter the first entry, say 0078.
2. Place the following Expression in the Control Source Property of a Text Box on your Form Bound to the [AutoCount] Field.
   

   =Format$(Val(DMax("[AutoCount]","tblTest"))+1,"0000")

3. Now, each new Number will automatically be generated in your requested Format, and these Numbers will be sequential with no gaps, as in:
   

   0079, 0080, 0081, 0082, 0083, ...