Create a field for text or memos

See Also

1. Open the table in Design View

2. Select the Fields tab

3. To insert a field within the table, click in the row below where you want to add the field, and then select Insert from the Field menu, or right-click on the field and select Insert
To add a field at the end of the table, select Add from the Field menu, or right-click in the fields grid and select Add

4. In the Name column enter the name of the field

5. In the Type column click the arrow and select CHAR or VARCHAR for text fields or select TINYTEXT, TEXT, MEDIUMTEXT or LONGTEXT for memos
For more information on MySQL field types, click

Note: The default length for CHAR and VARCHAR fields is 50. You can change this by setting the Length property.