Has any one got any ideas on how you can change the currency symbol from us dollars ($) to uk pounds (£)? I have changed the symbol in the access database however the problem still remains.

Many Thanks,

Hi there,

How do you display the currency symbol?

Usually, the "locale" determines the currency symbol. You'll need to switch the locale so it uses a £ instead of the $.

Search Google for "Session.LCID" AND currency and you'll get plenty of info.

Personally, I prefer to store currencies as normal numbers, and add a currency column to my table to keep track of the currency. I am not too happy with letting ASP or the database determine the currency symbol.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

:)You do have to set your local settings in Control Panel to English(United Kingdom) but I found that the tables in the database had a '$##:##' mask set on the format of the table. Click in any currency field in design view and change the mask to the word 'currency' from the pick list so that the default currency format £#.00 is used instead.