Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
i want to know the validation rule in MS access?
There must be 3 alphabets( no more and no less)
1 Answer
- Capt CrasherLv 61 decade agoFavorite Answer
That kind of validation You'll have to do on a form.
The Data Type can be controlled at the Table level, as well as the Maximum Length of each field, and a validation of "alpha only", but to say "no less than 3" will have to use the "count" function, so You'll have to script it into the Front End (the form that loads the table).
It may be best to ask this on a developers forum where back-and-forth discussions are permitted.
Source(s): Forums: http://www.utteraccess.com/ http://www.accessmonster.com/
