Microsoft KB Archive/94391

= ACC: Cannot Use &quot;y,&quot; &quot;n,&quot; &quot;t,&quot; or &quot;f&quot; in Yes/No Field =

Article ID: 94391

Article Last Modified on 1/18/2007

-

APPLIES TO


 * Microsoft Access 1.0 Standard Edition
 * Microsoft Access 1.1 Standard Edition
 * Microsoft Access 2.0 Standard Edition
 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q94391



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



SYMPTOMS
When you type the letter &quot;y&quot; or &quot;n&quot; 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 &quot;yes&quot; or &quot;no&quot; instead of the abbreviation &quot;y&quot; or &quot;n&quot; 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 &quot;y&quot; or &quot;n&quot; and Microsoft Access will fill in the words &quot;yes&quot; or &quot;no&quot; automatically.

