Group:  Microsoft Access ยป microsoft.public.access.formscoding
Thread: how can i check if an value is integer or string?

Geek News

how can i check if an value is integer or string?
h3llz 12/17/2008 10:17:00 AM
how can i check if an value is integer or string?
Re: how can i check if an value is integer or string?
Stefan Hoffmann <ste5an[ at ]ste5an.de> 12/17/2008 10:45:07 AM
hi,

h3llz wrote:
[Quoted Text]
> how can i check if an value is integer or string?

Public Function IsInteger(AValue As Variant) As Boolean

On Local Error GoTo LocalError

Dim dummy As Integer

Dummy = CInt(AValue)
IsInteger = True

Exit Function

LocalError:
IsInteger = False

End Function




mfG
--> stefan <--

Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net