hi im really new to access and i need data validation for a telephone number field. i need it so the user cannot enter any text in there only numbers. so far i have the following code:
Private Sub telephone_number_Enter()
If notNumeric Then
MsgBox "Only numerical characters allowed"
Cancel = True
End If
End Sub
this doesnt work i have opened the form in design view double clicked the text box and put it in there am i putting it in the wrong place or is the code wrong.
Private Sub telephone_number_Enter()
If notNumeric Then
MsgBox "Only numerical characters allowed"
Cancel = True
End If
End Sub
this doesnt work i have opened the form in design view double clicked the text box and put it in there am i putting it in the wrong place or is the code wrong.
