Testing Data Types

R

Ray C

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
 
J

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.
 
R

Ray C

Thank you John
RayC

John Nurick said:
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.
Click to expand...
 
Top