Help using format() for euros

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

liz - 28 Feb 2008 21:51 GMT

I am using a IIf statement to set the recordsource to format the type for a
text box. i.e. display £value or Evalue depening on country (option of only
2).

=IIf([Currency]=1,Format([Total Unit Price],"Currency"),Format([Total Unit
Price],"Euro"))

The trouble is instead of formatting to Euro it writes "Euro" into the
textbox.
I can see that "euro" might not be the correct term to write - but seems the
obvious one. I am not sure what to do......

Signature

thanks for any help
liz

Reply to this Message

Evi - 28 Feb 2008 23:10 GMT

use Format([Total Unit Price],"Euro" & "00.00") - you can replace the word
Euro with the symbol which is AltGr and 4 on my UK keyboard if you wish in
which case you can use Format([ProdCost],"?00.00")

> I am using a IIf statement to set the recordsource to format the type for a
> text box. i.e. display £value or Evalue depening on country (option of only
[quoted text clipped - 11 lines]
> thanks for any help
> liz

Reply to this Message

Evi - 28 Feb 2008 23:14 GMT

Sorry, that didn't come out in the Email.
The Euro symbol was replaced by a question mark by Outlook Express. Where
you can see the question mark in my function, place the Euro symbol.
Evi

> use Format([Total Unit Price],"Euro" & "00.00") - you can replace the word
> Euro with the symbol which is AltGr and 4 on my UK keyboard if you wish in
[quoted text clipped - 17 lines]
> > thanks for any help
> > liz

Reply to this Message