can I make a field that can auto-number which the format that I want??

As I know that there is two format for auto-number
but I don't like them

I want to number my own format

like
XXX-YYYYMM-ZZZZ

XXX is the category number that would be selected in the form connecting to table
YYYYMM is the date year and month
ZZZZ is another auto numbering

Can I do so

Check this thread out:

http://www.access-programmers.co.uk/forums/showthread.php?t=80648

It is along the same lines as what you are asking.


K