Question Show currency values as £ not $

[sTrongFuse]

By virtue of my work PC being required to talk "American" despite me being in the UK, my regional settings have to be set to English - United States. It's a pain in the you-know-where, but it can't be avoided as I work for a US company and I have to access their databases and applications.

I am currently developing a local database (UK use only) and I've managed to localise it to show the dates in the "correct" dd/mm/yyyy format but the one thing I cannot seem to be able to do is change the currency symbol in my forms/reports to £ instead of $.

I don't want to convert between the two currencies, I just want to enter a value, say £100, and for it to display as £100.00, and not $100.00 or 100.00 as seem to be the only two options available to me.

Can this be done?

T :banghead::banghead::banghead:

 

[NeutronFlux]

Format(100,"£#0.00")

 

[sTrongFuse]

Format(100,"£#0.00")

Thanks, although sadly I'm not much the wiser. Where do I put this? When I put it in the format box, the results in my report are gibberish.

 

[Simon_MT]

You really should store the Currency Value and Symbol. Yes you can change the Regional Settings but if you are in a mutil-currency environment explicit currency determination is required.

Simon

 

[NeutronFlux]

If you're putting it in the Format box, just use:
£#0.00

 

[sTrongFuse]

You really should store the Currency Value and Symbol. Yes you can change the Regional Settings but if you are in a mutil-currency environment explicit currency determination is required.

Simon

Thanks Simon,

That may end up being the solution I opt for.

My problem isn't that I'm in a multi currency environment, all the users are here in the UK and the only currency that will be used is UK £. The problem is that even though we are here in the UK, our regional settings have to be set to US to allow us to use some of our Head Office's applications. It's a bit of a pain but I guess the alternative is just to live with the $ sign.

T

 

[sTrongFuse]

If you're putting it in the Format box, just use:
£#0.00

That almost works, but it rounds everything to a whole number of pounds,

eg 2125.17 displays as £2125.00 and not £2,125.17 as I would want it.

 

[NeutronFlux]

Strange, it works for me. What about just:
£0.00
Otherwise, there might be some other setting such as Decimal Places that you've set. Or if your data is linked to a table, you've set the number type to Integer of some kind.

 

[Galaxiom]

£#0.00 Format property works for me with a Currency datatype field.

 

[sTrongFuse]

£#0.00 Format property works for me with a Currency datatype field.

Odd, it works for me now. Any idea how to get the comm seperator?

 

[sTrongFuse]

Strange, it works for me. What about just:
£0.00
Otherwise, there might be some other setting such as Decimal Places that you've set. Or if your data is linked to a table, you've set the number type to Integer of some kind.

I tried it again today and it worked. Strange! Still can't get the comma thousands seperator though.

 

[sTrongFuse]

Actually, ignore that last question, I just remembered £#,##0.00. All works fine now.

Thanks for all your help.

T