Search results

Just tried it, still allows numbers. I'm beginning to think that this task is impossible...

Sorry, I should've mentioned that. I'm applying it to the Surname field.

Hmmm... I tried it again, but it is still allowing other characters and numbers. I attached my .mdb to see if you could check where I've gone wrong.

Keeping it how it is in the screenshot, the field now accepts anything. Numbers, brackets, full stops, @ signs etc. Is this a problem in the code or just the position I've put it in?

Thanks Ken, Am I right in putting this as an After Update Event Procedure at Form level?

Really? That would be great. Thanks. It's just that I'm truly terrible at using Access. I'm more of an Excel man myself - it's just that the thing I'm working on NEEDS to be done in Access. I would be really gratefull if you could create a function which would get this to work. James

Hi, I'm really struggling to try and find a solution to a problem. I need to find a validation rule that only accepts: letters, spaces and hyphens (-) in the field. I have tried for at least 14 hours today and most of yesterday afternoon, but I just can't get it. The furthest I've got is...

I tried this code: Is Null OR Not Like "*[!((a-z) or ("*(Chr(32),Chr(45))*"))]*" but i got a popup saying: Reserved error (-3100); there is no message for this error. so i tried each of these codes seperately: Is Null OR Not Like "*[!((a-z) or (Chr(32),Chr(45))]*" Is Null Or Not Like...

*UPDATED*: NEW PEOBLEM (Validating a Surname) I need to validate a surname field which obviously can only consist of letters and occasionally spaces and/or hyphens. (i.e. van Driel or Johnson-Crooks) I managed to create a validation rule which would allow me to have space in the surname field...