Limit Columns Form For Free

To create multiple columns of fields, drag fields into the Column Drop Zones to the left or right of existing fields in the editor. To create multiple rows of fields, drag fields into the Row Drop Zones to the top and bottom of an existing row of fields in the editor.

Microsoft Access has a limit of 255 columns per table. If you attempt to link to an external table that has more than 255 columns, Access will retrieve the first 255 columns only. With a linked table, you cannot choose which columns are retrieved.

Data types for Access desktop databases Data TypeUsageSizeShort Text (formerly known as ?Text?)Alphanumeric data (names, titles, etc.)Up to 255 characters.13 more rows

Microsoft Access has a limit of 255 columns per table. If you attempt to link to an external table that has more than 255 columns, Access will retrieve the first 255 columns only. If, say, you want to retrieve the 256th column but not the first, you can use a pass-through query instead.

In Access, you can define up to 255 fields in a table. If you create 255 fields and then delete 10, Access does not release the fields from the internal column count.

Table AttributeMaximumNumber of characters in a field name64Number of fields in a table255Number of open tables2,048 including linked tables and the tables opened internally by AccessTable size2 gigabyte minus the space needed for the system objects11 more rows

In the Navigation Pane, right-click the table that contains the field that you want to change, and then click Design View. In the table design grid, select the field for which you want to change the field size. In the Field Properties pane, on the General tab, enter the new field size in the Field Size property.