Microsoft KB Archive/305532

= ACC2000: Expression Builder Causes Error with Strings That Have More Than 1023 Characters =

Article ID: 305532

Article Last Modified on 7/15/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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.



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 &quot;Symptoms&quot; section of this article.

Additional query words: pra

Keywords: kberrmsg kbbug kbpending KB305532

-

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

© Microsoft Corporation. All rights reserved.