J Jon123 Registered User. Local time Today, 16:42 Joined Aug 29, 2003 Messages 668 Feb 1, 2014 #1 I cant change the table propery to number only so is there an afterupdate code I could run on a field and check for alphanumartic charters ?
I cant change the table propery to number only so is there an afterupdate code I could run on a field and check for alphanumartic charters ?
pbaldy Wino Moderator Staff member Local time Today, 13:42 Joined Aug 30, 2003 Messages 36,157 Feb 1, 2014 #2 You can use the IsNumeric() function, and you'd want to check before, not after: http://www.baldyweb.com/BeforeUpdate.htm
You can use the IsNumeric() function, and you'd want to check before, not after: http://www.baldyweb.com/BeforeUpdate.htm