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:
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
- Start Microsoft Access 2000.
- Open the sample database Northwind.mdb.
- In the Database window, click Forms under Objects, and then click New.
- In the New Form dialog box, click Design View, and then click OK.
- Right-click in the detail section of the new form, and then click Build Event.
- In the Choose Builder dialog box, click Expression Builder, and then click OK.
- In the Expression Builder, create any expression that uses at least 1024 characters.
- Click OK to close the Expression Builder. Note that you receive the error message that is mentioned in the "Symptoms" section of this article.
Additional query words: pra
Keywords: kberrmsg kbbug kbpending KB305532