MS Access: VarType Constants
This MSAccess tutorial explains how to use VarType in Access with syntax.
Syntax
The syntax for the VarType function is:
VarType(variable_name)
It returns the type of value is currently stored in variable_name
Applies To
- Access 2013, Access 2010, Access 2007, Access 2003, Access XP, Access 2000
Return Values
The return values for VarType are:
| Constant | Value | Description |
|---|---|---|
| vbEmpty | 0 | Unitialized variable |
| vbNull | 1 | No valid data |
| vbInteger | 2 | Integer |
| vbLong | 3 | Long integer |
| vbSingle | 4 | Single-precision number |
| vbDouble | 5 | Double-precision number |
| vbCurrency | 6 | Currency |
| vbDate | 7 | Date |
| vbString | 8 | String |
| vbObject | 9 | Object |
| vbError | 10 | Error value |
| vbBoolean | 11 | Boolean |
| vbVariant | 12 | Variant |
| vbDataObject | 13 | Data Access Object |
| vbDecimal | 14 | Decimal |
| vbByte | 17 | Byte |
| vbLongLong | 20 | LongLong integer (only 64-bit platforms) * Access 2010 |
| vbUserDefinedType | 36 | User-defined type |
| vbArray | 8192 | Array |
Advertisements