field data types

The following table lists the field data types and their equivalent Visual Basic data types.

Field data type          Visual Basic data type

 

True/False                Integer

Byte                          Integer

Integer                      Integer

Long                         Long

Currency                   Double

Single                       Single

Double                      Double

Date/Time                 Variant

Text                          String

Long Binary               String or Variant; can be longer than 64K

Memo                        String or Variant; can be longer than 64K

 

Note that any kind of value can be stored in a Variant data type.