ACC2000: Expression Builder Causes Error with Strings That Have More Than 1023 Characters (305532)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q305532
Novice: Requires knowledge of the user interface on single-user computers.

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

SYMPTOMS

When you use the Expression Builder to create an expression that has between 1024 and 2048 characters, you may receive the following error message:
An expression can't be longer than 2048 characters.

The Access 2000 Help files do not indicate that there is any limitation on the length of an expression, and the limitation is not consistent with the limitations of the object receiving the expression.

RESOLUTION

To work around this problem, limit expressions that you create by using the Expression Builder to 1023 or fewer characters.

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 the Behavior

  1. Start Microsoft Access 2000.
  2. Open the sample database Northwind.mdb.
  3. In the Database window, click Forms under Objects, and then click New.
  4. In the New Form dialog box, click Design View, and then click OK.
  5. Right-click in the detail section of the new form, and then click Build Event.
  6. In the Choose Builder dialog box, click Expression Builder, and then click OK.
  7. In the Expression Builder, create any expression that uses at least 1024 characters.
  8. Click OK to close the Expression Builder. Note that you receive the error message that is mentioned in the "Symptoms" section of this article.
Modification Type:MinorLast Reviewed:7/15/2004
Keywords:kbbug kberrmsg kbpending KB305532
©2004 Microsoft Corporation. All rights reserved.