Change Format of “Number” Data Type

Advertisement

Like previous Access versions, Access 2010 also allows user to change format of all supported data types. This post covers changing format of Number data type. To change the format of the field having number data type, open the table in Design view, right click the table and click Design View.

446d1274347540-change-format-number-data-type-

In Design View, select the field having Number data type and from Field properties, under Format option, select a desired format.

445d1274347539-change-format-number-data-type-

Advertisement