Here is another way. I usually put a command button on my form, that when clicked will go through and verify all entries. So if we just have a command button and a text box on the form, the code would look something like:
Private Sub CommandButton1_Click()
If Not IsNumeric(TextBox1) Then
MsgBox "Only numbers may be entered in the text box"
TextBox1.Value = ""