Code to check for numeric data

[laurat]

I have a field in a database that was originally specified to be a text field, EmployeeID. Now the users want them to enter only their clock num, (originally it was last name and clock num). I cannot just convert the field to number because it will lose existing data. Is there any code I could write and put on the After_Update() that would check if the data entered was numeric only and if not give an error message??

Any input would be appreciated. Thank you.

 

[scottfarcus]

If Not IsNumeric(EmployeeID) Then
'Display your message here
End If