Microsoft KB Archive/142055

= ACC: INTL Finnish Regional Setting Breaks DateValue =

Article ID: 142055

Article Last Modified on 7/5/2002

-

APPLIES TO


 * Microsoft Access 2.0 Standard Edition
 * Microsoft Access 95 Standard Edition

-



This article was previously published under Q142055



Moderate: Requires basic macro, coding, and interoperability skills.



SYMPTOMS
When you use the DateValue function in a calculated field in a query, it returns the following error value:


 * 1) Error

Or when you use the DateValue function in Visual Basic for Applications, you receive the following error message:

In Microsoft Access version 7.0:

Type Mismatch

In Microsoft Access version 2.0:

Illegal function call



CAUSE
The cause depends on your operating system and regional settings:


 * In Microsoft Windows 95 or Microsoft Windows NT version 4.0, you set the Control Panel's Regional Settings, Regional Settings tab to Finnish and the Time separator to a period (.). There's no need to reboot to reproduce the problem.
 * In Microsoft Windows NT version 3.51, you set the Control Panel's Country setting to Finland and the Time separator to a period (.).
 * In Microsoft Windows version 3.1 and Windows for Workgroups version 3.11, you set the Control Panel's Country setting to Finland, which automatically sets the Time separator to a period (.).

NOTE: If the Time separator is set to a period and the Control Panel's Country or Regional Settings is set to Finnish or Finland, all Microsoft Access Date functions will fail to run whenever the Time portion of a Date/Time field has a value. However, for this problem to occur in most cases, you must manually set the Time Separator to a period (.). The Time separator is automatically set to a period (.) only when you choose Finland as the Country setting in Windows 3.1 or Windows for Workgroups.



RESOLUTION
Change the Time separator in the Windows Control Panel to a colon.



MORE INFORMATION

 * 1) In windows 95 or Windows NT version 4.0, in the Control Panel's Regional Settings dialog box, set the Regional Setting to Finnish and set the Time separator to a period (.).

In Windows version 3.1 or Windows NT version 3.51, set the Control Panel's Language setting to Finnish, which automatically sets the Time separator to a period (.).
 * 1) Open the sample database Northwind.mdb (or Nwind.mdb in version 2.0.).
 * 2) Open a new module.
 * 3) On the View menu, click Debug Window (or Immediate Window in version 2.0).
 * 4) Type the following line in the Debug window, and then press Enter:

?DateValue(now)

Note that you receive one of the errors listed in the

Additional query words: international int'l

Keywords: kberrmsg kbenv kbprb KB142055

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.