The type of variable you would use is VARIANT and you would use the ISTYPEOF keyword to deduce the type of data held in the variable and the various types including all the common ones can be deduced by applying the VARIANT TYPE CONSTANTS to an if statement.


I do believe it does not work (is not supported) in a SELECT CASE statement and is expected to be used in an IF THEN ELSEIF ELSE kinda statement.

DocZaf
{;->
Look for VARIANT in the helpfile.

VB5 SP3