Data Checking (1 Viewer)

[mkkashif]

hi,

if i want to check a field that it contains the text
how can i do that
example a field t1

if me.t1 ="what i have to put here"

msgbox "Please enter number in this field"
exit sub
end if

 

[trucktime]

Text

I'm sorry, but the question is not very clear.
At least, I don't understand what you are trying to do.
Please explain.

 

[pbaldy]

How about

If Not IsNumeric(Me.t1) Then
...

 

[mkkashif]

thanks

Dear thanks it's working
if i want to check the text what is the method to do .
i mean if i want that a field only contain text and no numeric how can i check.