Is it possible to have "validation rule" in MS Access for a column of text / string data type which is only numerical digits? And a "validation rule" that only allows the letter?
For a rule that will only allow numerical digits, can be used. can do the same thing with what you can do with this See more examples of Verification Rules If you are limiting the field then only numerical digits Why should not allow field numeric? Faucet or Not Like "* [! 0-9] *" This will reject anything which is not a number, you can call it with alpha characters
tap or "" [! Az] * "
No comments:
Post a Comment