Check if entry is number or text

[santosm]

Hi All,
I am doing a search function on a form and would like to just use one text box for that search. I would like to use the after update event to check whether the input is a number (could be regular integer or LONG) or text. Then use that to search on different fields to filter the form. How do I check the input to see whether it is a number or text?

Thanks,
Mark

[HansV]

You can use code like this:

Code: Select all

    If IsNumeric(Me.txtSearch) Then
        ' code for numeric values goes here
        ...
    Else
        ' code for text values goes here
        ...
    End If

where txtSearch is the text box.

[santosm]

Works! Thanks!