Because I do the filter in one textbox, it can access date, vendor name, and amount. When I open the form, I do filter Vendor name first, everything is OK, when I do filter date/amount first, then filter vendor name, it has error messge "You enter value in numeric field or larger than size."
Because I want the textbox can handle 3 datatype: Date, Amount, Text
The fix is fairly simple. Blank out the 'Format' line in the text box's Property Sheet, and have any data that is input to that text box 'hit' as text. Then you can use the IsNumeric() and/or IsDate() functions to test for the 'real' format. You might say something like
If IsNumeric(Me.txtTheTextBox) Then
Something . . .
ElseIf IsDate(Me.txtTheTextBox) Then
Something Else . . .