check dataentry

[Heita]

Hi!

One simple question.
I have textfields which are bound to integer datatypes. If the user types in text i want my own msgbox to "override" the messagebox that Access produces since it´s not good for the unsers.

E.g. check myself that the datatype is the correct one. If not, show MsgBox.

Thanx...

 

[Aivars]

private sub txtTextBox_BeforeUpdate(cancel as integer)
if not isnumeric(me.txtTextBox) then
msgbox "...."
cancel=true
end if
end sub

Aivars