Access: VarType Constants
The syntax for the VarType function is:
VarType(variable_name)
It returns the type of value is currently stored in variable_name
| 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 |
| vbUserDefinedType | 36 | User-defined type |
| vbArray | 8192 | Array |