Variant Types


The variant type is a special type that can contain values of the following types:

The variant type is the type of the field property of recordset objects, and is only used when accessing values from recordset fields (which can have a variety of types). Variant values are automatically converted to appropriate types, whenever they are used in expressions. So you can't use this type to declare variables or parameters.

The idea behind the variant type is to make database handling more robust, by isolating programs to some extent from the specific type of the fields in databases.