[AccessD] Format Valuta

In addition from a developers point of view it would be best to use a naming
convention like leszinsky orso. Eg. your textbox Currency would be named
txtCurrency... I believe there even is a naming convention (referral) on the
Access Developers website but I'm not sure:-)

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Erwin Craps -
IT Helps
Sent: donderdag 4 december 2003 11:42
To: Access Developers discussion and problem solving
Subject: RE: [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
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 2-12-2003
Tested on: 4-12-2003 12:47:59
avast! is copyright (c) 2000-2003 ALWIL Software.
http://www.avast.com