Application.EuroConvert (Access)

You can use the EuroConvert function to convert a number to euro, or from euro to a participating currency. You can also use it to convert a number from one participating currency to another by using the euro as an intermediary (triangulation). The EuroConvert function uses fixed conversion rates established by the European Union.

The following table contains the ISO codes that can be used with the SourceCurrency and TargetCurrency arguments.

EuroConvert (Number, SourceCurrency, TargetCurrency, FullPrecision, TriangulationPrecision)

EuroConvert(1.20,"DEM","EUR") 
EuroConvert(1.47,"FRF","DEM",TRUE,3)

Arguments

The following arguments are required:

Number (Double) - The number you want to convert, or a reference to a field containing the number.

SourceCurrency (String) - A string expression, or reference to a field containing the string, corresponding to the International Standards Organization (ISO) acronym for the currency you want to convert. Can be one of the ISO codes listed in the Remarks section.

TargetCurrency (String) - A string expression, or reference to a field containing the string, corresponding to the ISO code of the currency to which you want to convert the number. For a list of ISO codes, see the Remarks section.

Optional arguments

The following arguments are optional

FullPrecision (Boolean) - A Boolean value where True (1) ignores the currency-specific rounding rules (called display precision in the sourcecurrency argument description) and uses the 6-significant-digit conversion factor with no follow-up rounding. False (0) uses the currency-specific rounding rules to display the result. If the parameter is omitted, the default value is False.

TriangulationPrecision (Integer) - An Integer value greater than or equal to 3 that specifies the number of significant digits in the calculation precision used for the intermediate euro value when converting between two national currencies.