Short Text data type result can have up to 243 characters. Note, the Calculated data type isn't available in MDB file formats.ĭependent on the data type of the Result Type property.
You can designate different result data types from the expression. You can create an expression that uses data from one or more fields. Note, the Attachment data type isn't available in MDB file formats. You can attach files such as pictures, documents, spreadsheets, or charts each Attachment field can contain an unlimited number of attachments per record, up to the storage limit of the size of a database file. Up to 8,192 (each part of a Hyperlink data type can contain up to 2048 characters). Pictures, graphs, or other ActiveX objects from another Windows-based application.Ī link address to a document or file on the Internet, on an intranet, on a local area network (LAN), or on your local computer Unique value generated by Access for each new record.īoolean (true/false) data Access stores the numeric value zero (0) for false, and -1 for true. Monetary data, stored with 4 decimal places of precision. Up to about 1 gigabyte (GB), but controls to display a long text are limited to the first 64,000 characters.įor more information, see Using the Large Number data type.įor more information, see Using the Date/Time Extended data type. See The Memo data type is now called “Long Text” for more information on the Long Text details. Large amounts of alphanumeric data: sentences and paragraphs. The following table lists the data types available in desktop databases in Access 2013 and later versions.
0 kommentar(er)
