French version of Access causing a program error

[closesupport]

My application is being used by a French-Canadian company. The application works fine "in english". But with a French version of Access installed the following error occurs:

The Microsoft Jet database engine does not recognise 'Faux' as a valid field name or expression.

Now, I reckon the Faux translates to False. So does that mean that the French version of Access is complaining about lines such as:

blnNotifyNewCall = False

Any ideas?

Hanging on your every thread

Pete

http://www.closefitsoftware.com

 

[SteveR77]

Pete,

Faux is indeed false, and yes it is the localization of the application that is complaining.

Options are these use the numeric values for true and false (-1 and 0 respectively)

Alias your field for False so it is Faux: False.

Use and IIF statement to change the string.

IIF([True/false]=0,"Faux","Vrai)


HTH,


Steve

 

[closesupport]

Thanks Steve.

Hanging on your every thread

Pete

http://www.closefitsoftware.com