Microsoft KB Archive/209700

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

Article ID: 209700

Article Last Modified on 6/29/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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.

