M mkkashif Registered User. Local time Today, 15:13 Joined Sep 1, 2004 Messages 88 Dec 13, 2004 #1 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
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
T trucktime Registered User. Local time Today, 16:13 Joined Oct 24, 2004 Messages 556 Dec 13, 2004 #2 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.
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 Wino Moderator Staff member Local time Today, 15:13 Joined Aug 30, 2003 Messages 36,157 Dec 13, 2004 #3 How about If Not IsNumeric(Me.t1) Then ...
M mkkashif Registered User. Local time Today, 15:13 Joined Sep 1, 2004 Messages 88 Dec 15, 2004 #4 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.
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.
