Quoting Post Archived Topic: It will not be bumped to the top of the forum. Topic need help with MS Access validation rules! Membername   Not a member? Sign Up Free (takes 20 seconds) Password   Forgotten your password? Post Font: Verdana Arial Black Georgia Comic Sans Impact   Size: Tiny Normal Big Huge   Color: Default Dark Red Red Orange Brown Green Olive Cyan Blue Dark Blue Indigo Black [ Check Spelling ] [ Post Preview ] [ LiveTags ] Quote: from [m]Sachacohen2[/m] at 9:59 am on Feb. 22, 2008[quote]How do you write the validation rule for when you only want letters allowed no numbers? Or what do you write when you only want numbers to be allowed nothing else? :stressed: [/quote] FAQ Keyword Search: Post Options Favorites Manager Notify me of new replies to this topic by email Notify me of new replies to this topic by private message Original Post Sachacohen2 Posted at 9:59 am on Feb. 22, 2008 How do you write the validation rule for when you only want letters allowed no numbers? Or what do you write when you only want numbers to be allowed nothing else?

Replies DefaultTo0 Posted at 11:11 am on Mar. 18, 2008 Put 'number' as the data type - this will serve for all basic needs. I believe that there is an input mask that you can use to specify only numbers.  I know that the letter 'L' means 'allow one letter'.  Unsure how to specify that it can be of any length though.