Microsoft KB Archive/278868

= ACC2002: Query Criteria Text Changes to N'My Criteria' in an Access Project =

Article ID: 278868

Article Last Modified on 11/6/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



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 &quot;N&quot; 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.

Additional query words: prb stored procedure function view added placed put prefixed

Keywords: kbprb KB278868

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.