bodylojohn
Registered User.
- Local time
- Today, 14:48
- Joined
- Dec 28, 2005
- Messages
- 205
Hello everyone,
The thing I want to do is check if the value entered in a textbox is an integer. If it is...then great.
If it isn't then display an errormessage.
I tried this:
If CInt(Me.txtMedewerker_ID) = Me.txtMedewerker_ID Then
MsgBox ("It's an integer.")
intID = Me.txtMedewerker_ID.Value
Else
MsgBox ("Not an integer.")
Me.txtMedewerker_ID.SetFocus
End If
But if I type in an 'a' I get an errormessage that the types do not match.
What am I doing wrong?
the field me.txtMedewerker_ID is Unbound.
The thing I want to do is check if the value entered in a textbox is an integer. If it is...then great.
If it isn't then display an errormessage.
I tried this:
If CInt(Me.txtMedewerker_ID) = Me.txtMedewerker_ID Then
MsgBox ("It's an integer.")
intID = Me.txtMedewerker_ID.Value
Else
MsgBox ("Not an integer.")
Me.txtMedewerker_ID.SetFocus
End If
But if I type in an 'a' I get an errormessage that the types do not match.
What am I doing wrong?
the field me.txtMedewerker_ID is Unbound.