You can set or change the properties of a column within the grid that appears when you view the table in Column Properties view or when you design a single table.
To set column properties
Note The data types available in your database typically have default values. Many databases have rules concerning allowable property values. For example, a binary data type is often limited to a length between 1-255. If you type an invalid value for properties with such limitations, a message box will appear.
The new setting takes effect in the database diagram as soon as you press the TAB key or click outside the cell. The new setting is saved in the database when you save the table or your diagram.
Note You can also set column properties in Custom view for any columns you've chosen to display in this view. For more information about Custom view, see Changing a Table View.