[AccessD] Format Valuta

Ah I can tell you that....

There is a difference in reserved words in international versions of
Access.
Valuta is the reserved word in another access language version (dutch,
french etc).

Currency is the reserved word in VBA....works in all version.
Stuff to watch out for.

I'm not even sure if you use "Valuta" on a textbox that this will work
if you use the database in another language version of Access....


Erwin



-----Oorspronkelijk bericht-----
Van: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] Namens Gustav Brock
Verzonden: donderdag 4 december 2003 9:16
Aan: Access Developers discussion and problem solving
Onderwerp: Re: [AccessD] Format Valuta


Hi Pedro

> Hello Thanks for the answers already,

> but suddenly i remembert a similar question from me a few months ago.
> Gustav Brock then suggested            ........ , "currency").
> I tried this and it works.
> What i don't understand, why is "Valuta" working on a unbound textbox 
> as control source, but doesn't work in the if statement in code????

That's because you probably run not the US version but a localized
version of Access. In the GUI localized wording is used while code must
always be in US English.

/gustav

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