Function to find a number in string

[LonghronJ]

Is there a function available that I can determine whether a field has a number in the string? For an example, "DJ007Hhg" returns Yes and "Heghelz" returns No.

[June7]

Have to roll your own. Example http://www.utteraccess.com/forum/Fin...-t1746052.html

An expression in query or textbox can return True/False, no VBA required.

IIf([fieldname] LIKE "*[0-9]*", True, False)

Do you need to know what the number is? Will it always be only one digit?

[orange]

Try

Function HasNumber(sInput As String) As Boolean
 HasNumber = IIf(sInput Like "*[0-9]*", True, False)
End Function

[LonghronJ]

Have to roll your own. Example http://www.utteraccess.com/forum/Fin...-t1746052.html

An expression in query or textbox can return True/False, no VBA required.

IIf([fieldname] LIKE "*[0-9]*", True, False)

Do you need to know what the number is? Will it always be only one digit?

I just need to know if one exists. This works perfectly. Thanks.