B babs Feb 11, 2009 #1 Is it possible to add an alpha-numberic 8 digit (autonumbering) field to Access 2007?
R Roger Carlson Feb 11, 2009 #2 You would have to program one yourself. The Autonumber datatype is a Long Integer only and you have no control over its value. Here are a couple of samples that illustrate how to do it yourself: AutonumberProblem.mdb http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=395 Increment Alpha Field.mdb http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=21 -- --Roger Carlson MS Access MVP Access Database Samples: www.rogersaccesslibrary.com Want answers to your Access questions in your Email? Free subscription: http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
You would have to program one yourself. The Autonumber datatype is a Long Integer only and you have no control over its value. Here are a couple of samples that illustrate how to do it yourself: AutonumberProblem.mdb http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=395 Increment Alpha Field.mdb http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=21 -- --Roger Carlson MS Access MVP Access Database Samples: www.rogersaccesslibrary.com Want answers to your Access questions in your Email? Free subscription: http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
