In cretaing a table, how do I format a field to accept alpha characters only. No numeric. Thank you
P PCF Parks Jan 19, 2006 #1 In cretaing a table, how do I format a field to accept alpha characters only. No numeric. Thank you
B Bob M via AccessMonster.com Jan 19, 2006 #2 Place this in the Validation Rule of the field: ="a" And <="Z" Click to expand...
R Roger Carlson Jan 19, 2006 #3 Incidentally, you might want to wait more than 8 minutes before asking your question again. -- --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
Incidentally, you might want to wait more than 8 minutes before asking your question again. -- --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
P PCF Parks Jan 19, 2006 #4 Bob Thank you so much for the quick response, it worked like a charm! Pat
