MySafeInfo

Microsoft Access Data Types

Technology 14 records updated 2026-07-17

Microsoft Access Data Types, with data type, description, and storage.

Get this data

GET https://mysafeinfo.com/api/data/microsoftaccessdatatypes

JSON XML CSV Download CSV

Sort, page, randomize, and download with query parameters; see the documentation.

Try it live

Run a request against microsoftaccessdatatypes straight from your browser. Add your API key to lift the row cap and return every record. The call goes to the API and nothing is stored here.

Preview

First 14 of 14 records. Click a column to sort these rows.

ID DataType Description Storage
1 Text Use for text or combinations of text and numbers. 255 characters maximum
2 Memo Memo is used for larger amounts of text. Stores up to 65,536 characters. Note: You cannot sort a memo field. However, they are searchable
3 Byte Allows whole numbers from 0 to 255 1 byte
4 Integer Allows whole numbers between -32,768 and 32,767 2 bytes
5 Long Allows whole numbers between -2,147,483,648 and 2,147,483,647 4 bytes
6 Single Single precision floating-point. Will handle most decimals 4 bytes
7 Double Double precision floating-point. Will handle most decimals 8 bytes
8 Currency Use for currency. Holds up to 15 digits of whole dollars, plus 4 decimal places. Tip: You can choose which country's currency to use 8 bytes
9 AutoNumber AutoNumber fields automatically give each record its own number, usually starting at 1 4 bytes
10 Date/Time Use for dates and times 8 bytes
11 Yes/No A logical field can be displayed as Yes/No, True/False, or On/Off. In code, use the constants True and False (equivalent to -1 and 0). Note: Null values are not allowed in Yes/No fields 1 bit
12 Ole Object Can store pictures, audio, video, or other BLOBs (Binary Large OBjects) up to 1GB
13 Hyperlink Contain links to other files, including web pages
14 Lookup Wizard Let you type a list of options, which can then be chosen from a drop-down list 4 bytes

Notes