How Do You Set The Number Of Decimal Places For A Table Field In Access 2003?
In Access, you can alter many field properties to help you manage your databases, including how many decimal places appear in a table field. Follow the steps below. Start up Access and open a database. Determine the table and field where you want to set the decimal-place property. Select the field in Design View, and choose the “Decimal Places” property. You can set it at any number from 0 to 15, or you can select “Auto.” Save your settings and exit Access.