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

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.

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

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 "Symptoms" section of this article.