ACC2000: Cannot Use "y," "n," "t," or "f" in Yes/No Field (209700)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q209700
Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access database (.mdb).

SYMPTOMS

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 just 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 creating a Yes/No field, click Microsoft Access Help on the Help menu, type Create a Yes/No field in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.
Modification Type:MajorLast Reviewed:6/29/2004
Keywords:kberrmsg kbprb KB209700
©2004 Microsoft Corporation. All rights reserved.