Wed. May 22nd, 2024
MS Access Data Types and Properties
MS Access Data Types and Properties

Ms Access Data Types is one of the basic knowledge for the beginner in most programming software and MS Access when you creating table with Table Design, you may notice the Data Type field. Data Type is how you determine the value of the field, whether it is text, date, or number.

 What is AutoNumber data type in access?

Ms Access Data Types-1
Ms Access Data Types-1

What is a field property?

The list of the Data Type can be seen in this table:

Data Type Description Limitation
Short Text (2013+ ver.) alphanumeric values. 255 characters
Text (2007/2010 ver.) alphanumeric values. 255 characters
Long Text (2013+ ver.) Large amount alphanumeric values. 1 GB, displayed 64000 characters
Memo (2007/2010 ver.) Large amount alphanumeric values.
Number Numeric values. It is a separate data type for currency. Due to the limitation size, it is consists of: Byte, Integer, Long Integer, Single, and Double. 1, 2, 4, 8, or 16 bytes
Date/Time Contains the Date (Day, Month, Year) and Time (hour, minute, second) value. 8 bytes
Currency Monetary values. 8 bytes
AutoNumber The unique value generated by Access for each new record. 4 bytes
Yes/No Only contains Yes or No Value 1 byte
OLE Object Pictures, graphs, or other ActiveX objects from another Windows-based application. 2 GB
Hyperlink Text or combinations of text and numbers stored as text and used as a hyperlink address. 8192 link
Attachment Attached images, spreadsheet files, documents, and other types of supported files to the records in your database. 2 GB
Calculated Field Results of a calculation which refer to other fields in the same table. You need Expression Builder to create the calculation. Depends on the data type of Result Type
Lookup Displays either a list of values that is retrieved from a table or query. For more information, read LookUp Wizard Tutorial. Depends on the data type of lookup field
Read Also:  MS Access Case Statement Syntax in Multiple Conditions


How do you change the datatype in access?

The Data Type not only contains how the data should be, but restrict the data entry to the field. For example, if you tried to input a letter into a numeric field it will automatically show the validation warning.

Ms Access Data Types-2
Ms Access Data Types-2

The Data Type on the upper list are for the field value in the table. Some of them can be used in VBA Code.