Testing Data Types

[Guest]

In BASIC there was a method of testing Data Types IsStr(String) would equal
True, IsNum(String) would equal False etc. I can not seem to find any
equivalent command in Access, there must be one. Any help please?

Thanks RayC

 

[Douglas J. Steele]

There are IsDate and IsNumeric functions, but that's pretty much it.

 

[Guest]

Pretty dismal selection but thanks anyway
RayC

There are IsDate and IsNumeric functions, but that's pretty much it.

 

[John Nurick]

Hi Ray,

Usually one can use VarType() to learn either the data type of an
ordinary variable or the type of the value that has been assigned to a
Variant.

IsDate() and IsNumeric() will tell you whether a string can be
interpreted as a date or number respectively.

 

[Guest]

Thank you John
RayC

Hi Ray,

Usually one can use VarType() to learn either the data type of an
ordinary variable or the type of the value that has been assigned to a
Variant.

IsDate() and IsNumeric() will tell you whether a string can be
interpreted as a date or number respectively.