[AccessD] Getting the type of a variant

Wed Dec 5 17:33:01 CST 2007

Late answer, but anyway: the function TypeName() may be the most handy -
Dim varMyVar1 As Variant, varMyVar2 As Variant
varMyVar1='XXX'
varMyVar2= 100
Debug.Print TypeName(varMyVar1) --> String
Debug.Print TypeName(varMyVar2) --> Integer

/Asger

-----Oprindelig meddelelse-----
Fra: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] På vegne af jwcolby
Sendt: 2. december 2007 19:17
Til: 'Access Developers discussion and problem solving'
Emne: [AccessD] Getting the type of a variant

How do you get the type of data currently stored in a variant?

John W. Colby
Colby Consulting
www.ColbyConsulting.com 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com