Data type constants in DAO
If you have
used code that documents
your tables using DAO, the data type of each field will be
represented by a number. This table decodes those data type
constants for you, so that your reports are easier to understand.
| Value | DataType | Description |
|---|---|---|
| 1 | dbBoolean | Boolean |
| 2 | dbByte | Byte |
| 3 | dbInteger | Integer |
| 4 | dbLong | Long |
| 5 | dbCurrency | Currency |
| 6 | dbSingle | Single |
| 7 | dbDouble | Double |
| 8 | dbDate | Date |
| 9 | dbBinary | Binary |
| 10 | dbText | Text |
| 11 | dbLongBinary | Long Binary |
| 12 | dbMemo | Memo |
| 15 | dbGUID | GUID |
| 16 | dbBigInt | BigInt |
| 17 | dbVarBinary | Var Binary |
| 18 | dbChar | Char |
| 19 | dbNumeric | Numeric |
| 20 | dbDecimal | Decimal |
| 21 | dbFloat | Float |
| 22 | dbTime | Time |
| 23 | dbTimeStamp | Time Stamp |
