validation rule for a valid hex value

[kimmer]

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?

[Oralloy]

Are you doing this in Access Basic, or as a field validation rule?

[kimmer]

I am coding a validation rule on a form for a field that is entered in hex

[NeoPa]

I don't believe you can refer to the item in the ValidationRule, which would be necessary to handle :

IsNumeric("&H" & [ControlName])

I suggest you handle this check in the AfterUpdate event property of the control instead.