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

• 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