Show All

Change the default data type and text size (ADP)

Note  The information in this topic applies only to a Microsoft Access project (.adp).

You can change the default data type and the default size of a text field for a new column created in Database Designer or in Table Designer.

1. On the Tools menu, click Options, and then click the Tables/Queries tab.
2. Do one or more of the following:
   • To set the default data type for a column, select a Microsoft SQL server data type from the drop-down list box under Default field type.
   • To set the default size for a text field (char, nchar, varchar (n), nvarchar (n)), enter a number in the Text text box under Default field sizes.