Create a field for numbers or currency

1. Open a table in Design view.
   
   
2. To insert the field within the table, click in the row below where you want to add the field, and then click Insert Rows on the toolbar.

   To add the field to the end of the table, click in the first blank row.

3. In the Field Name column, type the name for the field, following Microsoft Access object-naming rules.
   
   
4. In the Data Type column, click the arrow and select either Number or Currency. For information on which data type to use, click .
   
   
5. If you are creating a Number field, in the bottom part of the window set the FieldSize property to the size you want. For more information on field sizes, click .
   
   
6. To set a display format for your field, in the bottom part of the window click in the Format box, click the arrow, and select the format you want. You can also create a custom display format, if the predefined formats don't meet your needs. For more information, click .
   
   
7. Set the other field properties, if desired.

   How?

Note   Changes made to the currency formats that are specified by double-clicking Regional Settings in Windows Control Panel will be automatically reflected in your database for Currency fields. However, this only affects the format; no conversion of currency values will be made.