Does MUI on Access XP affect VBA type conversion functions?

  • Thread starter Thread starter Stephan Auerochs
  • Start date Start date
S

Stephan Auerochs

Hi,

Does the Multilingual Language Interface for Office XP affect the type
conversion functions in Access?
For example if the user switch the MS Office language from English to
German, then typing a number into a textbox, and VBA uses CSng to convert
the textbox value, does the CSng-function expect ',' for the decimal
separator or '.' ?
Or do the type conversion functions generally use the regional settings in
the control panel?
I don't have the MUI pack for Office XP, but have to work on an Access
project for a customer who is using Office XP with MUI, so I want to avoid
potential traps here.

Regards,
Stephan
 
As I understand it - >but I am no expert here< - the explicit conversion
(C*) functions generally use the regional settings for such things. Maybe
you could create a small test database, send it to one of your clients, &
have him click the button & report-back whgat he sees on the screen.

Beware of the old, "dates in SQL", trick. They should be specified as
#mm/dd/yyyy", >regardless of the regional setting for day/month versus
month/day order<.

HTH,
TC
 
Back
Top