Microsoft KB Archive/282360

= ACC2002: &quot;Enter Parameter Value&quot; Dialog Box Displays Square Brackets Around Parameter &quot;Name&quot; =

Article ID: 282360

Article Last Modified on 11/6/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q282360



Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access database (.mdb).



SYMPTOMS
When you run a query that requires criteria to be entered, the field name for which the criteria is required in the Enter Parameter Value dialog box is displayed with square brackets, as it appears in the query design grid.



CAUSE
This occurs when the parameter in the query is [Name], which is a reserved string.



RESOLUTION
Change the text of the criteria in Design View to something other than [Name].



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



Steps to Reproduce Behavior

 * 1) Open the sample database Northwind.mdb.
 * 2) Open the Products By Category query in Design View.
 * 3) Type [Name] as criteria for the ProductName field.
 * 4) Run the query and note that the Enter Parameter Value dialog box displays [Name] instead of the expected Name.

Additional query words: pra

Keywords: kbbug kbnofix KB282360

-

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

© Microsoft Corporation. All rights reserved.