Check for numbers in a combo box

[slenish]

Hello,

Ok I have a combo box that I set up so that you can only enter in letters in to it. At the moment it works great! If you enter numbers in you get an error message but I just did another test where if I enter a combination of numbers and letters it will save. How do i get the box to check for if numbers are mixed in with letters to error out?



Here is the code I have so far,

If IsNumeric(Me![Combo57].Text) Then
  MsgBox "You must enter letters in this field", vbYes, "Invalid Entry"
   Response = acDataErrContinue
    Me![Combo57].Undo
     Exit Sub
End If

Not sure If I can add to this one, or do i need to make another if statement.

Apperciate the help

[Stressed]

Hello,

Ok I have a combo box that I set up so that you can only enter in letters in to it. At the moment it works great! If you enter numbers in you get an error message but I just did another test where if I enter a combination of numbers and letters it will save. How do i get the box to check for if numbers are mixed in with letters to error out?

Here is the code I have so far,

If IsNumeric(Me![Combo57].Text) Then
  MsgBox "You must enter letters in this field", vbYes, "Invalid Entry"
   Response = acDataErrContinue
    Me![Combo57].Undo
     Exit Sub
End If

Not sure If I can add to this one, or do i need to make another if statement.

Apperciate the help

I posted some code that will prevent numbers from being entered. No need for IsNumeric...

https://www.accessforums.net/database-design/setting-field-only-accept-text-characters-not-numbers-4763.html#post16706

[c_smithwick]

set your combo box input mask property to "???????????" (number of question marks equal to the maximum length of your possible entries. This will restrict entry to letters only, with each position optional so you can enter from 0 to the maximum number of letters permitted.