ACC2002: "Enter Parameter Value" Dialog Box Displays Square Brackets Around Parameter "Name" (282360)


The information in this article applies to:

  • Microsoft Access 2002
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.

MORE INFORMATION

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.
Modification Type:MajorLast Reviewed:11/6/2003
Keywords:kbbug kbnofix KB282360
©2003 Microsoft Corporation. All rights reserved.