Is it possible to prevent a user inputting an alphanumeric number in a feild using vb

[wedd]

Hi, is it possible to prevent an alphanumeric number being inputted into a table as well as preventing alphanumeric digits from appearing in a drop down list box; I created with a list of telephone numbers; using vba or an expression etc? In other word,s I would like to auto-filter out telephone numbers that lead with more than one zero; as well as if the user enters a letter instead of numbers. I would like a message to pop up to tell the user that the entry is an invalid number. Is this possible to do? If so, do you have any example of code which can do this?


Thanks for your contributions

[SoftwareMatt]

Yes this is possible.
Though I am wondering why you don't just set the field type to a number then Access will not allow any alphanumeric entries?