ACC: Cannot Use "y," "n," "t," or "f" in Yes/No Field

 Last reviewed: April 23, 1997
Article ID: Q94391
The information in this article applies to:
  • Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97

SYMPTOMS

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

When you type the letter "y" or "n" into a field, you may receive the following error message: 

   The value you entered isn't appropriate for this field

CAUSE

You are not typing the entire word into a Yes/No Boolean field, a True/ False field, or an On/Off field.

RESOLUTION

Type the entire word "yes" or "no" instead of the abbreviation "y" or "n" in a field defined with a Yes/No data type. The capitalization does not matter.

In a combo box or list box, you can enter just a "y" or "n" and Microsoft Access will fill in the words "yes" or "no" automatically.

REFERENCES

For more information about how to use a combo box or list box with Yes/No data type fields, please see the following article in the Microsoft Knowledge Base: 

   ARTICLE-ID: Q109381
   TITLE     : ACC1x: How to Display Yes/No Choices in a Combo Box or
               List Box

Keywords : kberrmsg kbusage TblDatyp
Version : 1.0 1.1 2.0 7.0 97
Platform : WINDOWS
Hardware : X86
Issue type : kbprb
Resolution Type : Info_Provided

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.

Last reviewed: April 23, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.