[AccessD] Getting the type of a variant

John,

You don't say in which version of Accessm but in Access 2007, look at the
VarType method.

http://office.microsoft.com/en-us/access/HA012289321033.aspx

Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Sunday, December 02, 2007 1:17 PM
To: 'Access Developers discussion and problem solving'
Subject: [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