PRB: "The Value You Entered Isn't Appropriate" Error Message

Article ID: Q129718
Creation Date: 02-MAY-1995
Revision Date: 19-SEP-1996

The information in this article applies to:

Microsoft Access versions 2.0, 7.0

SYMPTOMS

Novice: Requires knowledge of the user interface on single-user computers.

When you enter a date correctly in a field that is formatted for a Medium Date data type, you may receive the following error message in Microsoft Access for Windows 95 versions 7.0:

   The value you entered isn't appropriate for the datatype or field
   property setting for this field.

Or in Microsoft Access version 2.0, you may receive the following message:

   The value you have entered isn't appropriate for this field.

CAUSE

The Language setting in the Regional Settings tool in Control Panel is set to a language, such as Swedish, in which dates are expressed with the year first, and then the month and the day. When you enter a date with the month first, and then the day and the year, you receive the error message.

RESOLUTION

To work around this behavior, set the language setting in the Regional Settings tool to a language, such as the English(United States), in which dates are expressed with the month first, and then the day and the year.

STATUS

This behavior is by Design.

MORE INFORMATION

Steps to Reproduce Behavior

 1. Open the sample database NORTHWIND.MDB (or NWIND.MDB in version 2.0).

 2. Create a form and add a text box.

 3. Set the text box's Format property to Medium Date.

 4. View the form in Form view.

 5. Type "12-May-94" (without the quotation marks) in the text box and
    press the TAB key. Note that 12-May-94 appears in the text box as you
    expect.

 6. Open Control Panel and double-click the Regional Settings icon.

 7. In the Language box, select Swedish, and then click OK.

 8. Restart the computer and return to Microsoft Access.

 9. Select the date you typed in the text box, and then press the DELETE
    key to delete the date.

Type "12-May-94" (without the quotation marks) in the text box and
    press TAB. Note that you receive the error message described earlier
    in this article.

REFERENCES

For more information about formatting dates, search for "date formats," and then "Format Property - Date/Time Data Types" using the Microsoft Access Help menu.

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.