How to change currency symbol in microsoft access

New posts. Search forums. Log in. JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding. You are using an out of date browser. It may not display this or other websites correctly. You should upgrade or use an alternative browser. Change Curency Symbol in Field. Thread starter thorsonb Start date Sep 14, Local time Today, Joined Sep 7, Messages Good day all. I have a data base, and I have a table, a column called "Price" for this column, i want it to be a currency, so i selected my "Data type" as currency.

Thanks in advance. DCrake Remembered. Local time Today, Joined Jun 8, Messages 8, In the table you can set the field format from Currency to Euro. Local time Today, Joined Feb 26, Messages 2, You are better to have Currency in your Table rather than creating confusion as to what Currency the Price should be. Currency Use the thousand separator; follow the settings specified in the regional settings of Windows for negative amounts, decimal and currency symbols, and decimal places.

Euro Use the euro symbol euro , regardless of the currency symbol specified in the regional settings of Windows. Fixed Display at least one digit; follow the settings specified in the regional settings of Windows for negative amounts, decimal and currency symbols, and decimal places.

Standard Use the thousand separator; follow the settings specified in the regional settings of Windows for negative amounts, decimal symbols, and decimal places. Scientific Use standard scientific notation.

Custom Formats Custom number formats can have one to four sections with semicolons ; as the list separator. Each section contains the format specification for a different type of number. Section Description First The format for positive numbers. Second The format for negative numbers. Third The format for zero values. Fourth The format for Null values. If you use multiple sections but don't specify a format for each section, entries for which there is no format will either display nothing or default to the formatting of the first section.

You can create custom number formats by using the following symbols. Symbol Description. Separators are set in the regional settings in Windows. Display a digit or 0. Digit placeholder. Display a digit or nothing. The value is multiplied by and a percent sign is appended.

E— or e— Scientific notation with a minus sign — next to negative exponents and nothing next to positive exponents. As it is, we are denied both choices. All versions of Access work this way. The behaviour is counter-intuitive, inconsistent with the rest of regional settings, and contradicts the documentation. To develop an application that does correctly adapt to the user's currency settings, you must reset the Format property of every affected control every time you open a form or report.