ACC: Cannot Use "y," "n," "t," or "f" in Yes/No Field (94391)
The information in this article applies to:
- Microsoft Access 1.0
- Microsoft Access 1.1
- Microsoft Access 2.0
- Microsoft Access for Windows 95 7.0
- Microsoft Access 97
This article was previously published under Q94391 Novice: Requires knowledge of the user interface on single-user computers.
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 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:
109381 ACC1x: How to Display Yes/No Choices in a Combo Box or
List Box
| Modification Type: | Major | Last Reviewed: | 5/9/2003 |
|---|
| Keywords: | kberrmsg kbprb KB94391 |
|---|
|