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

ID: Q209700

The information in this article applies to:

Microsoft Access 2000

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.

Additional query words: prb


Keywords          : kberrmsg kbdta TblDatyp 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbprb

Last Reviewed: May 13, 1999