Testing Returned Data

[Guest]

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

 

[Allen Browne]

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

 

[Guest]

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