Change the default data type and text size (ADP)
From Microsoft Office Access 2003
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.
- On the Tools menu, click Options, and then click the Tables/Queries tab.
- 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.