Testing Data Types

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
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...
 
Back
Top