[AccessD] Currency display issue

Hi Arthur

You could simply set the format property to €0.00 or £0.00 etc. or use the same format string in Format().
For those currencies without a symbol, you could spell out the ISO currency code and wrap it in Chr(34) like 

"SEK "0.00

Thus, as Stuart suggests, the general solution would be to have the ISO 4217 table and add a field with the format string of your choice.

/gustav

>>> artful at rogers.com 09-02-2005 23:30:56 >>>
I've got a form and a subform (LOL). Actually I don't, I just thought 
I'd say that.

I have a different problem, and suspect that our Euro members may have 
the solution I need.

There's a Currencies table, a Products table, and Sales and SalesDetails 
tables.

Suppose you live in New Orleans, but you want to buy a product whose 
price is expressed in Euros. Fine so far. Next sale, customer is in 
Quebec, product expressed in Yen.

I need the form to respond intelligently with its Currency columns. We 
have mandated that only one currency can exist per sale (and all its 
details), but said form must be able to switch from the $ sign to the 
Euro sign to the Yen sign etc., based on the value of the CurrencyID 
column.

I have no idea how to do this. At the moment every amount has a $ sign 
in front of it, even if the currency is Euros. Not only does it look 
stupid, it confuses the users.

Any suggestions?

TIA,
Arthur