Assignment 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.

Update Conversion RatesFrom Setup, enter Company Information and click Company Information.Click Currency setup.In the Active Currencies or Inactive Currencies list, click Edit Rates.Enter the conversion rate between each currency and your corporate currency.Click Save.

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.

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.

Update Conversion RatesFrom Setup, enter Company Information and click Company Information.Click Currency setup.In the Active Currencies or Inactive Currencies list, click Edit Rates.Enter the conversion rate between each currency and your corporate currency.Click Save.

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.

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.