Within my Opportunity Details grid I have several bespoke currency fields.

We have Multi-Currency enabled, which at the moment is placing a GBP at the end of my value.

1000.00 GBP

My users do not like this.  I have two questions relating to the formatting of the currency.

1.  How do I remove the GBP, I have tried setting the property "Display Exchange Rate Code" to False, but this has no effect.

2.  I need to format my value with no trailing zeros - 1000.00 should read 1000, again I have tried formating the filed - In Data Bindings I have specified a format string £%.0m - but again this does not change the format.

Can anyone, help

Thanks

Sarah

Hi Sarah,

I'm dealing with the same issue. I'm considering removing the SLX Currency control altogether and binding the data field to an ASP.NET label or text box. But I believe there's some validation and/or display client script that comes with the SLX Currency control, and I don't necessarily want to lose it (unless all it's doing is generating the unwanted formatting!).

Anyone have a simpler solution?

Thanks!
Scott

From what I recall, the Currency Control uses .Net formatting for Currency, so it may have to do more with your Currency Settings (or the Servers).

This is what I got ouf ot the FormatCurrencyValue function from the Currency control via Reflection, from what I can tell the Currency Code that gets appended can be controlled via the DisplayCurrencyCode property:

public string FormatCurrencyValue(string value, string defaultValue)
{
    if (this.MultiCurrency())
    {
        this.LoadExchangeRate();
        if (this.DisplayCurrencyCode)
        {
            this._currencySymbol = this._currentCode ?? "";
        }
    }
    string cleanValue = this.GetCleanValue(value);
    if (string.IsNullOrEmpty(cleanValue))
    {
        return defaultValue;
    }
    string str2 = (Convert.ToDouble(cleanValue) * this.ExchangeRate.Value).ToString("C" + this.DecimalDigits);
    if (this._currencySymbol == this._currentCode)
    {
        str2 = str2.Replace(CultureInfo.CurrentCulture.NumberFormat.CurrencySymbol, "");
        str2 = str2 + (str2.EndsWith(" ") ? this._currentCode : (" " + this._currentCode));
    }
    return str2;
}

Also, trailing zeros can be controlled via the DecimalDigits property.

Now, I checked the Control itself, and not the Control Adapter, so it is possible that some of these properties are not available within App Archited.