Unwanted euro symbol

rbuser

Once upon a time I planned for the UK to adopt the Euro and
built in spare fields in my table called eurolinenet etc.

Finding an urgent need for a currency field I used these fields
for another purpose. Their display format is $#,0.00;-$#,0.00.

If I change it to £#,0.00;-£#,0.00 it fixes the euro display
issue but what amazes me is that RB (I assume) is clever enough
(too clever in this case) to pick up the word euro!

nicocizik

Hi Pat,

I'm a bit unclear about what is happening here. Where is the word "Euro"
being displayed? ReportBuilder does not have any code in it to display the
names of currencies. Could you perhaps have Euros set as your default
currency in your windows settings? If you would like to see how
ReportBuilder uses the display format, please see the ppDisplayFormat.pas
file.

--

rbuser

The field name is EuroLineNet.

Nowhere else is euro involved, if I change the $ to £ it is corrected for me
but presumably the $ is a general currency display format that must pick up
the word euro somehow.

All I know is that it showed a euro symbol only where the field name was
Eurosomething. Nowhere else. And that it went back to the £ symbol if I set
the $ dollar to £. Other currency field are fine with the $ left in - ie the
prevailing regional currency settings are applied ie £.

nicocizik

Hi Pat,

As a test, try taking ReportBuilder out of the equation and just print the
EuroLineNet field directly from the dataset to be sure this is not your
database software adding the extra formatting. As I said before,
ReportBuilder does not contain any code to display the names of currencies.
Maybe I'm not understanding the question? Let me know.

--