ACC2002: Query Criteria Text Changes to N'My Criteria' in an Access Project (278868)
The information in this article applies to:
This article was previously published under Q278868 Moderate: Requires basic macro, coding, and interoperability skills.
This article applies only to a Microsoft Access project (.adp).
SYMPTOMS
When you apply text criteria to tables in the Query Designer, a capital letter "N" may be added in front of the criteria.
CAUSE
This behavior can occur if the data type for the field to which the criteria is applied allows Unicode characters, such as fixed-length character fields that are defined as nChar or a variable-length character fields that are defined as nVarChar. The Query Designer automatically adds the N (Unicode) prefix to the criteria.
For example, when you create a query and enter criteria against the Country field of the Customers table in the NorthwindCS sample database to limit the result set to Customers in France, 'France' will be automatically converted to N'France'. This is because the Country field is defined as nVarChar.
RESOLUTION
The query will run properly with the added N, so you do not need to make any changes.
STATUS
This behavior is by design.
| Modification Type: | Major | Last Reviewed: | 11/6/2003 |
|---|
| Keywords: | kbprb KB278868 |
|---|
|