Euro Symbol (1 Viewer)

[Extra_Cover]

I cannot find this anywhere!!!

Can anyone tell me how to format a euro symbol using MS-Access 2000?

I have the current format set but would really like the euro symbol rather than 'EU'.

Curr1: IIf([curr_code] Like "EU*",Format([Local Value],"\EU0.00"),Format([Local Value],"$0.00"))

 

[Kiwiman]

Howzit

Try the format called EURO.

That would be on the Format tab of the control property - Format = EURO. THis will show the values with the EUR) symbol

 

[Extra_Cover]

Thanks for reply Kiwiman.

I cannot format the control to euro as it also may be dollars or sterling. I can detect what currency the value is but then need to apply the correct format.

 

[Simon_MT]

Try putting the currency symbol into a table and output the symbol then the amount.

Simon

 

[Kiwiman]

Howzit

No thinking try.

Expr1: IIf([cur]="EUR",Format([Invoice],"€#,###.00"),IIf([cur]="USD",Format([invoice],"$#,###.00"),Format([invoice],"currency")))

But I would go with Simons suggestion to put the symbol in a table etc.

Qucik key to insert the EURO symbol - CTRL + ALT + 4

 

[Extra_Cover]

Thanks for response. It was the euro symbol I was struggling to display. CTRL + ALT + 4 worked fine. As per Simons suggestion good idea to put symbols in a table.


Problem solved. Cheers.

 

[Simon_MT]

Kiwiman,

What part of NZ are you from? I'm a Wellingtonian.

Simon

 

[Kiwiman]

Howzit

I'm a hurricanes fan too but from Hawkes Bay \ Poverty Bay area. Went to uni at Vic though - great city Wellington.