B
BADAVEG
Guest
OK friends, I'm new to Access so nobody laugh when you read this. I'm trying to create a table which includes a "last name" field. Of course it's a text field, and I want to allow just letters and a "dash" (hyphen), since many last names are hyphenated. My problem is, how do I get the hyphen in and not allow any other special characters (or numbers)? I tried an input mask to allow just alpha characters, but then of course the dash isn't allowed. To allow input of the dash I changed the mask to 'C's but that permits ANY character, which you sure don't want in a name. So how do I set the field up for JUST alpha characters and only the special character of dash? (Is it possible to keep the C's in my input mask but create some validation that weeds aout all numbers and the other special characters? If so, would somebody please fill me in before I have a nervous breakdown or heart attack?). MS Help is NOT much help when it comes to validating.
Related question: I'm in my cubicle spending half the day trying to solve this thing through trial-and-error, because I don't understand how to create validations. Is there some book(s) someone can recommend that goes into DETAIL about how validations are created, how to build expressions, and especially how all the functions that can be used for validating work. Like I said, MS Help just doesn't give you much. (If all this is located in more than one source, please provide as many as you can).
Signed
About to Lose it in Chicago
Related question: I'm in my cubicle spending half the day trying to solve this thing through trial-and-error, because I don't understand how to create validations. Is there some book(s) someone can recommend that goes into DETAIL about how validations are created, how to build expressions, and especially how all the functions that can be used for validating work. Like I said, MS Help just doesn't give you much. (If all this is located in more than one source, please provide as many as you can).
Signed
About to Lose it in Chicago