[AccessD] currency format

Erwin Craps ERCR at ithelps.be
Sun Jul 20 15:02:53 CDT 2003


I find this a very intresting issue...

I'm not sure if it is a good thing to use the windows currency format...
I could lead sending out invoices in some currency while it really should be something else.

On the other hand if you don't use the windows format you need to re-hard code your app if you need to sell your app to a non EURO country...


When using currency in format property or format function you will use the windows setting.

You can hard code if you use € #.##0,00 in format property or format function.

 Format( 123.45,"€ #.##0,00")
This is independent of windows setting...

Erwin


-----Oorspronkelijk bericht-----
Van: Gustav Brock [mailto:gustav at cactus.dk] 
Verzonden: zaterdag 19 juli 2003 8:22
Aan: Access Developers discussion and problem solving
Onderwerp: Re: [AccessD] currency format


Hi Pedro

Try this:

  .item("price").value = Format(Nz(Me![txtPrice]), "Currency")

/gustav


> is there a format for a Euro currency field, so that the Euro sign is 
> displayed also when i use the following piece of code: 
> .item("price").value = Nz(Me![txtPrice]), for mail merge into a
> wordletter, with code: {DOCPROPERTY "Price"\*MERGEFORMAT}

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


More information about the AccessD mailing list