Testing Returned Data

#1 (**permalink**) 28-Jul-2006, 08:35 AM

In Basic, I was always able to test returned data to see if it was String or
Numeric:-
If isstring(a) then
if isnum(a) then etc
but there does not seem to ne the same test available within Access VB. I am
sure that there must be and I am just not able to find it. Can anyone help?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13296-testing-returned-data.html

Thanks

*

#2 (**permalink**) 28-Jul-2006, 08:35 AM

See Help on these functions:
VarType()
TypeName()
IsNumeric()
IsDate()

To test for a field with no value:
IsNull()

If you are using functions that have optional arguments of type Variant that
may not be supplied, see:
IsMissing()

To test for a Variant that is uninitialized, see:
IsEmpty()

To test if an object variable is not initialized:
If MyObject Is Nothing Then
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13296

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13296
Reply to group, rather than allenbrowne at mvps dot org.

"Ray C" wrote in message
news:EB6F1836-DD25-430B-A021-CC2BEA85F529@microsoft.com...
> In Basic, I was always able to test returned data to see if it was String
> or
> Numeric:-
> If isstring(a) then
> if isnum(a) then etc
> but there does not seem to ne the same test available within Access VB. I
> am
> sure that there must be and I am just not able to find it. Can anyone
> help?
>
> Thanks

#3 (**permalink**) 28-Jul-2006, 08:36 AM

Thanks for this Alan. I tried "isnum() and isnumber() isstring() etc, etc
but, of course these would not work. I could not find them in the Help files
because I did not know the name to request help on.

Thanks once again aAan

Ray C

"Allen Browne" wrote:

> See Help on these functions:
> VarType()
> TypeName()
> IsNumeric()
> IsDate()
>
> To test for a field with no value:
> IsNull()
>
> If you are using functions that have optional arguments of type Variant that
> may not be supplied, see:
> IsMissing()
>
> To test for a Variant that is uninitialized, see:
> IsEmpty()
>
> To test if an object variable is not initialized:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13296
> If MyObject Is Nothing Then
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Ray C" wrote in message
> news:EB6F1836-DD25-430B-A021-CC2BEA85F529@microsoft.com...
> > In Basic, I was always able to test returned data to see if it was String
> > or
> > Numeric:-
> > If isstring(a) then
> > if isnum(a) then etc
> > but there does not seem to ne the same test available within Access VB. I
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13296
> > am
> > sure that there must be and I am just not able to find it. Can anyone
> > help?
> >
> > Thanks
>
>
>