Sunday 15 July 2012

database - "Validation Rule" in MS Access for a string column for having only numeric digits -


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. 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] * "

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?

No comments:

Post a Comment