By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,968 Members | 1,541 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,968 IT Pros & Developers. It's quick & easy.

validation rule for a valid hex value

P: 9
i am validating entry for a field which is an 8 character hex field. Do anyone have any suggestions to how I code this validation rule?
Jul 29 '10 #1
Share this Question
Share on Google+
3 Replies

Expert 100+
P: 983
Are you doing this in Access Basic, or as a field validation rule?
Jul 30 '10 #2

P: 9
I am coding a validation rule on a form for a field that is entered in hex
Jul 30 '10 #3

Expert Mod 15k+
P: 31,769
I don't believe you can refer to the item in the ValidationRule, which would be necessary to handle :
Expand|Select|Wrap|Line Numbers
  1. IsNumeric("&H" & [ControlName])
I suggest you handle this check in the AfterUpdate event property of the control instead.
Jul 31 '10 #4

Post your reply

Sign in to post your reply or Sign up for a free account.