Help using format() for euros

  • Thread starter Thread starter liz
  • Start date Start date
L

liz

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......
 
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")
 
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

Evi said:
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")
liz said:
I am using a IIf statement to set the recordsource to format the type
Click to expand...
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......
Click to expand...
Click to expand...
 
Back
Top