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

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:

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

Keywords : kberrmsg TblDatyp
Version : 1.0 1.1 2.0 7.0 97
Platform : WINDOWS
Issue type : kbprb


Last Reviewed: March 13, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.