Claim Delete US Currency Field For Free

Currency formatCreate a table with a field of type Currency.In the lower pane of table design view, set the Format property to "Currency".Save the table, and close the database.Open the Windows Control Panel. Go to Regional Options, and change the Currency setting.Open your database again.

On the Home tab, click the Dialog Box Launcher next to Number. Tip: You can also press Ctrl+1 to open the Format Cells dialog box. In the Format Cells dialog box, in the Category list, click Currency or Accounting. In the Symbol box, click the currency symbol that you want.

When you apply the Currency format to a field, Access displays a currency symbol and two values after the decimal point, but it does not change the field's data type.

Click the Format box in the Field Properties section and type a greater than symbol( > ). Your table should look like figure. Access will display the contents of the State field in uppercase, even if it was entered in lowercase.

The datatype for currency is MONEY. the money datatype will store the information only, without the format: in your example the information is 11.23 so that's what is saved into the database. the $ sign is part of the format so it will not be stored into the money field.

Use the setValue() method to set the value of a currency field.

Select the cells that you want to format and then, in the Number group on the Home tab, click the down arrow in the Number Format box. Choose either Currency or Accounting.