changing currency format from dollar to euro

[zickler]

I am using a free donload shopping cart a.shopKart for a project but it is set up to use dollars, I want to change the currency format to euro or sterling can I change this in the Access database, if so how please ?

Thanks in advance

 

[KenReay]

Hi

Is the currency symbol not a windows locale setting?

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Gazonice]

Hi,

I avoid the currency format in favour of decimal format to reduce the risk of errors caused by floating point calculations.

I use a table to store the currency symbol (and other information), then draw it off from an invisible form (currency):

TextBox = Form![currency].[curr_symbol] & [currency_field]

your main form might want to open the currency form in invisible mode, using it's OnOpen event.

This allows your users to choose any symbol they like.

hope this helps,

Garry